Forum Discussion

ElliotP's avatar
ElliotP
Post Prodigy
9 years ago

Difference between two measures

Evening,   I've calculated the proportions between a table of Group Sizes and the number of group sizes & Table Sizes and the number of those tables.   When I attempt to calculate the difference ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago

ElliotP

Thanks for sharing the pbix. However I'm not finding the page as the snapshot in the original post and measures named as m1, m2, var1, var2 are also missing. Could you be more specific?

  • ElliotP's avatar
    ElliotP
    Post Prodigy
    9 years ago

    Sorry I sent the wrong pbix. Here's the new one: https://1drv.ms/u/s!At8Q-ZbRnAj8hk7mZ-n67sX1bj1H

     

    M1 is called [proportion2] in the table 'group size - 2'

     

    M2 is called [proportiont] in the table 'Table Configuration (2)'.

     

     

    • Eric_Zhang's avatar
      Eric_Zhang
      Microsoft Employee
      9 years ago

      ElliotP

      Instead of GroupSize/TableSize showing the difference for Catergory 1 as 0.53, it's showing these values.

       

       

      I am digging into you pbix, however I still don't get the quoted? Do you mean what visuals are showing values not expected? Can you be more specific?

      • richbenmintz's avatar
        richbenmintz
        Resident Rockstar
        9 years ago

        Is there a reason why you have chosen to use calculated columns rather that measures in your 'group size' table to represent the numbers you are dividing? If you create a relationship between the 'group size' and 'group size join' tables you should get the sums you want without the additional calculated columns using measures. 

         

        you will also notice that [proportiont] will always be 100% in the top lesft hand corner visual as you have not used the 'Table Size' column in the visual and your measure [proportaint] requires the 'table size' column from 'tableConfiguration (2)' to be on rows columns or filters to get a value other than 1.

         

        I would sugget creating table size and group size dimensions that would join to your facts, then all facts would be slicable by a single table value.

         

        Hope that make sense

         

        Richard