Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
85 | |
46 | |
28 | |
21 |