PowerBI - How to count duplicate values

preview_player
Показать описание
How to count all duplicate values from a table, using DAX.
Also how to count all values with an exact number of occurrences.
  1. JiFacts
  2. PowerBI
  3. DAX
  4. BI
  5. SQL
  6. Count
Рекомендации по теме
Power BI: DAX 0:02:24

Power BI: DAX How to Count the Total Rows of a Table

Power BI DAX 0:09:54

Power BI DAX Function Count tutorial for Counting Column Values

How to do 0:02:13

How to do COUNTIF in Power BI

How to COUNT 0:09:07

How to COUNT in Power BI // COUNT, COUNTA, DISTINCTCOUNT, COUNTBLANK, COUNTROWS, COUNTX, COUNTAX

Count Specific Items 0:03:02

Count Specific Items in a column Power BI

COUNT, COUNTA, COUNTAX, 0:04:39

COUNT, COUNTA, COUNTAX, COUNTX - DAX Guide

Power BI DAX 0:11:57

Power BI DAX for Beginners: COUNT, COUNTA, COUNTX, COUNTAX, COUNTBLANK, DISTICTCOUNT, COUNTROWS

PowerBI - How 0:06:57

PowerBI - How to count duplicate values

Math/Stat/Iterator functions in 1:19:35

Math/Stat/Iterator functions in DAX, Filter functions, and Time intelligence Functions in DAX

Count Rows or 0:06:02

Count Rows or Sum Columns based on single or Multiple conditions in PowerBI | MiTutorials

A technique to 0:07:37

A technique to count anything in Power Query and some in DAX too

DAX CALCULATE Function 0:08:45

DAX CALCULATE Function Made Easy to Understand (just one word)

How to Count 0:06:39

How to Count Number of Rows in Power BI

Power BI DAX 0:01:25

Power BI DAX - CountRows vs Count: Which is better?

Measures vs. calculated 0:06:00

Measures vs. calculated columns in DAX and Power BI

Power BI DAX: 0:06:01

Power BI DAX: How to Use the CALCULATE Function

Cumulative Count In 0:03:33

Cumulative Count In Power BI

Power BI - 0:02:29

Power BI - How to count table rows | Row Count Function

How to count 0:04:21

How to count number of working days per month

Introducing CALCULATE in 0:13:57

Introducing CALCULATE in DAX

Count of Unique 0:05:29

Count of Unique Values DistinctCount in Power BI Through Power Query Group By Transformation

Tutorial- 23 0:05:51

Tutorial- 23 COUNT, COUNTA & COUNTX DAX functions Power Bi

Count Distinct Customers 0:02:52

Count Distinct Customers and Products DAX Power BI

Mastering DAX: How 0:05:15

Mastering DAX: How to Rank a COUNT output in Power BI

Комментарии
Автор

This is exactly what i needed! Worked so well! Great explanation!

klxni
Автор

AMAZING!!! This is exactly what i was looking for to solve a request at work. Thank you for the clear explanation and break down as to how/what was happening as you compiled the whole expression.

mmmpretzel
Автор

This tutorial was exactly what I needed. Please make more Power Bi tutorials!

renmbs
Автор

you are awesome. exactly what I was looking for, with detailed explanation of the thought process. Thank you for taking the time to explain it

michaelswchan
Автор

This is brilliant, thank you so much :)

bilab
Автор

How can i show the duplicate count for every name? In your case i want to show i a table and maybe a graph that john is repeated 3 times and Olivia is repeated 2 times. I have different customers names and when they got a discount, i want to show that John is repeated 5, times for example, and 3 times he got a discount, Marrry is repeated 3 times and she got a discount only 1 times. At the end i want to show only the once that ot a discount more than 2 times.

DiCh-jpms
Автор

Could you please mak a video for claculate duplicale more the 2 times thae last 3 or 4 4 weeks

eliasnassif
Автор

Please use ZOOM because it's impossible to read, thnks

eliasaguilar
Автор

I want to show the name, how do i do that?

hassanny