Forum Discussion

deepak91g's avatar
deepak91g
Icon for Resolver II rankResolver II
8 years ago
Solved

Best way to present %age data

Please suggest me to best way to aggregate percentage data around a category.   Data sample is here   Year % of Players Ethnicity % of WAR 1947 98.30% White 99.90% 1948 98.50% Wh...
  • v-yuta-msft's avatar
    8 years ago

    Hi deepak91g,

     

    To present your report, you can use line chart which can express relationship between “% of players” and “% of wars” easily like below:

    If you want to use aggregation, I recommend you to use DAX formula like countx().

     

    To make aggregation meaningful, one option is calculating count values. For example, we can count how many % of Players values greater than 95% within each Ethnicity group.

     

    If you want to achieve different requirements, could you please provide more details about your requirements?

     

    Best Regards,

    Jimmy Tao

  • deepak91g's avatar
    deepak91g
    8 years ago