Forum Discussion

Niemeyer's avatar
Niemeyer
Regular Visitor
3 years ago
Solved

Counting accumulated lines

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

 

8 Replies

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      3 years ago

      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's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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's avatar
      Niemeyer
      Regular Visitor
      3 years ago

      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's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        3 years ago

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