Forum Discussion
ElliotP
9 years agoPost Prodigy
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 ...
Eric_Zhang
9 years agoMicrosoft Employee
A pbix could help to better understand your requirement. Please share a pbix.
ElliotP
9 years agoPost Prodigy
The 'itemdetailsdogfood$' is the data table.
Link to my pbix: https://1drv.ms/u/s!At8Q-ZbRnAj8hkQ0BAAxiXnUdKJm
- Eric_Zhang9 years agoMicrosoft Employee
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?
- ElliotP9 years agoPost Prodigy
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_Zhang9 years agoMicrosoft Employee
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?