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

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

  • ElliotP's avatar
    ElliotP
    Post Prodigy
    9 years ago

    Sorry;

     

    In 'Group Size - 2' there is the measure [proportion2]. This measures the proportion of the GroupSize (like a group of 3 people) by GroupCount as a % of the total Group Count.

     

    In 'TableConfiguration (2)' there is a measure [proportiont]. This measures the proportion of the TableSize (like table size of One, five, etc) byte the total number of seats in the column 'number'.

     

    I'm trying to to complete the operation [proportion2] - [proportiont]. This will contrast the number of groups as a proportion of all group sizes throughout the day against the current table configuration to be able to see if for example 50% of your customers are in groups of One, but your table configuration is 90% for 10 people tables.

     

    At the moment when I use the measure [grp2] in the 'Group Size - 2' table, I recieve the top two graphics "NumberOneG" & "NumberOneT" on the left side. The difference between them is using either [tablesize] or [groupsize] from their respective tables as axes. Neither of the calculated values are correct and I'm not sure why.

     

    Sorry for not being more clear early, I spent a decent bit of time and I couldn't work out.

     

    richbenmintzI like your suggestion but I'm unable to create a relationship between 'Group Size - 2' and 'Group Size Join - 2'; thoughts?

     

    There is a relationship between 'Group Size - 2' (one of my data tables) and 'Table Configuration (2)', so I'm not sure why I'm seeing different values between the axes' choice.