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?

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.