Forum Discussion

flaviobdsti's avatar
flaviobdsti
Helper I
4 years ago
Solved

Count grouped data

Hello guys! I need a little help.
I searched before posting, but didn't find anything that could help me...

I have the following data:

CodeProductAmount
11Apple1,000
23Apple1,250
34Apple1,321
19Apple1,439
11Apple1,250
11Apple1,300
19Apple1,100
19Apple1,986
34Apple1,324

 

Based on the above data, I created a metric to sum the AMOUNT column grouped by CODE and got the result below:

CodeProductAmount
11Apple3,550
23Apple1,250
34Apple2,645
19Apple4,525

 

Based on this result I need to display how many CODE I have. In the example above the answer would be four (4), however when I make a metric Power BI does not consider the grouping and returns nine (9) instead of four (4) CODE. Can anyone tell me where I'm going wrong?

I tried to use the functions DAX like Count with distinct and Group by, but without success!

I appreciate who can help me!

  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure how your desired outcome looks like, but please try to write below measure and put it into the card visualization.

     

    Distinct count measure: =
COUNTROWS ( VALUES ( 'Tablename'[Code] ) )

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    4 years ago

    Hi,

    I am not sure how your desired outcome looks like, but please try to write below measure and put it into the card visualization.

     

    Distinct count measure: =
COUNTROWS ( VALUES ( 'Tablename'[Code] ) )