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.
Hello,
the ABC analysis shows the summed turnover per customer group.
These can change through different filters.
I would now like to count how many rows A, B or C are displayed.
So in this case
A = 2
B = 3
C = 4
The values A, B and C were previously determined in a measure.
No matter what I have tried with COUNT, everything in the table is counted, but not the displayed rows.
Does anyone have a tip?
Best regards
Volker
Solved! Go to Solution.
Perfect, thank you very much 🙂
@Niemeyer
Also check the other solution if you are interested in summing the values at the total level (as in the first solution it shows 0)
Hi @Niemeyer
Create a disconnected table (let's call it ABC) which contains the 3 values A, B, & C in a single column. Place the column in a table visual along with the following measure
Count =
SUMX (
VALUES ( 'Table'[Kundengruppe / Kunde] ),
INT ( [Umsatz ABC] = SELECTEDVALUE ( ABC[Value] ) )
)
Thanks for the suggestion, here is the result.
All rows of the source table are counted as C?
We were already that far 😉
Please note that it is not the source table that is counted but the displayed, grouped, summed and filtered visual.
@Niemeyer
Please make sure that no relationships have been automatically created by power bi.
also please share the dax that you have used.
I have provided the anonymous evaluation (pbix) with test data here:
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 |
---|---|
52 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
75 | |
58 | |
47 | |
16 | |
12 |