Counting accumulated lines

[Niemeyer]

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

[Niemeyer]

Perfect, thank you very much 🙂

[tamerj1]

@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)

[tamerj1]

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] ) )
)

[Niemeyer]

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.

[tamerj1]

@Niemeyer 
Please make sure that no relationships have been automatically created by power bi. 
also please share the dax that you have used.  

[Niemeyer]

I have provided the anonymous evaluation (pbix) with test data here:

https://1drv.ms/u/s!AnOtUz8wrIZqmrId12FdCAGJabRSyg?e=puOZpX

[tamerj1]

@Niemeyer 
Or with total if required

[tamerj1 · Accepted solution]

@Niemeyer