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.
I want to count the number of subcategories. Data looks like below:
Rank Vendor Group
Elite Avot
Elite Ivak
Essential Boch LTD
Essential Futh Elec
Provisional Active Dach
Provisional Alloc Mac
Provisional Alldoc
Provisional Anpro
Provisional Falow
Provisional Match
Provisional Beast Elec
The data above is a matrix. Vendor group is a column that comes from Vendor Info Table and Rank is a measure calculated based on their score calculated using another measure. I want to count how many Elites and how many Provissonals we have in different card or table. How can I do this please?
Solved! Go to Solution.
Hi @Anonymous ,
First create a dim table as below:
Then create a measure as below:
Measure 2 =
SWITCH(SELECTEDVALUE('Dim table'[Column1]),"Elite",CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[Measure]="Elite")),
"Essential",CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[Measure]="Essential")),
"Provisional",CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[Measure]="Provisional")))
Finally you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
I am only getting the total number of vendor groups as shown in snippet above.
Hi @Anonymous ,
First create a dim table as below:
Then create a measure as below:
Measure 2 =
SWITCH(SELECTEDVALUE('Dim table'[Column1]),"Elite",CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[Measure]="Elite")),
"Essential",CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[Measure]="Essential")),
"Provisional",CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[Measure]="Provisional")))
Finally you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hello, try making this measure:
=COUNTROWS(Table)
here it is at work:
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |