Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Distinct count % issue

Hi.. 

 

Need some assistance while calculating Distinct count i need a % of row total as well which doesnt shows the right % can any one suggests how to calculate it

Where as green highlighted are the correct percentages but when i put the field to show values as % of row total its not correct

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    If the same numbers repeat the total of distinct count changes. I think you need to do something like so that total adds up

     


    row = sumx(summarize(Table, Table[Month],"_dis" ,distinctcount(Table[ID])),[_dis])
    Over GT = sumx(summarize(all(Table), Table[Month],"_dis" ,distinctcount(Table[ID])),[_dis])

     

    Appreciate your Kudos.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous 

    Could you provide a sample data with your used formula, A sample pbix would be best. There isn't enough information to figure out what is going wrong.

    Best regards
    Paul Zheng