Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Percentage Differences Boggle

This doesn't strike me as being that difficult, but either because it's Monday or my brain isn't working well, I cannot seem to be able to figure out how to calculate a percentage difference!   My ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    I had already been down that road. The solution was to add the order to the tool tips (minimum), then select it from the "More Options" on the visual itself.

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous it is not very clear what you are trying to achieve and what is not working? Can you share sample data and expected results.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    One measure with the axis being the distance category.

    All I want to do is calculate the percentages of each column. I could create a measure for each category and then a percentage measure too, but that seems a bit tedious.

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      Anonymous add following measure to get %

       

      % = 
DIVIDE(
COUNT(Table[Distance Category]),
 CALCULATE( COUNT( Table[Distance Category] ), ALLSELECTED( Table[Distance Category] ) )

      you can also have a measure for count and replace COUNT in above expression with your measure

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I tried that, but it returns 1 for all categories:

         

        Pct = DIVIDE([Distance Count], CALCULATE([Distance Count], ALLSELECTED('Distance Category'[Distance Category])))
         
        Distance Count = COUNT(Mbr_Geo_Data[Mbshp_Address])