Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Total in Power BI Tables

Hi,

 

I have a simple dataset which looks like this : 

 

cluster nameser no
cluster11
cluster12
cluster1 
cluster14
cluster25
cluster2 
cluster27
cluster33
cluster34
cluster3 
cluster30

 

In power BI I want to count distinct the values against each cluster which works, but the total field at the bottm shows wierd values.

Can anyone explain what is happening?

Total shoud be 4+3+4 but power bi shows it as 8

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    8 years ago

    Hi Anonymous

     

    The value 8 is only the distinct count of column 'ser no'. So there are 8 distinct values: 'blank',1,2,4,5,7,0,3 as below picture. If you want to change the total, you may create a measure as below to get the correct total.

    Count =
VAR a =
    SUMMARIZE (
        'Sample',
        'Sample'[cluster name],
        "count", DISTINCTCOUNT ( 'Sample'[ser no] )
    )
RETURN
    IF (
        HASONEVALUE ( 'Sample'[cluster name] ),
        DISTINCTCOUNT ( 'Sample'[ser no] ),
        SUMX ( a, [count] )
    )

     

    Regards,

    Cherie

2 Replies