Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a column in my data which is called "NPS Category", which classifies each Case Number listed. Each row in the data either have the values of "Promoter", "Detractor", or "Neutral" within this NPS Category column.
I'm trying to create a measure similar to the below for each of the possible Category values (Promoter, Detractor, or Neutral):
NPS Neutral Count =(Count([Case Number]Where([NPS Categories]="Neutral")))
This would give me a final count of the number of rows that have the value of "Neutral". The "Case Number" would be a unique value for each row.
I'm having trouble figuring how to do this with DAX, and was hoping someone could help?
Thanks!
Solved! Go to Solution.
Measure = CALCULATE ( DISTINCTCOUNT ( Table[CaseNumber] ), Table[NPS Category] = "Neutral" )
Measure = CALCULATE ( DISTINCTCOUNT ( Table[CaseNumber] ), Table[NPS Category] = "Neutral" )
Not sure what I was doing wrong before - but that worked perfect, thanks!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |