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.

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])
parry2k's avatar
parry2k
Super User
7 years ago

Anonymoushmm, seems like I'm missing something here, looks like you have multiple table with relationship, can you share what does that relationship looks like

 

also can you make sure on x-axis you are using the same distance category column which you used in DAX ALLSELECTED Function.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    For a moment, it worked, but now I'm befuddled.All I am using this other table for is to get the X axis member to appear in order.

     

    The Pct formula:

    Pct = DIVIDE([Distance Count], CALCULATE([Distance Count], ALLSELECTED('Distance Category'[Category])))
    Percentages are correct, but the order is off.
    If I replace "Category" with "Distance Category", then I get all values equal to 1.0
     
    • v-lili6-msft's avatar
      v-lili6-msft
      Community Support
      7 years ago

      HI, Anonymous 

      You could use Sort by column in Power BI Desktop for order.

      for the result is 1.0, it involves row context in calculation, you could learn about it.

      If you still have problem, please share your sample pbix file.

       

      Best Regards,

      Lin

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        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.