Forum Discussion
Calculate the variance between two (variable) selections
Thanks Anonymous but you made a "fixed" solution where you compare LBE2 with LBE1, but the user can make every selection from the slicer. So also LBE3 with LBE1 or LBE2 with LBE3.
Also in your measure you are treating field addendum as a field of a table in the averagex. But it is not a table field it is a measure.
I compiled a sample workbook here so you can see the general setup and data (real file is much bigger and complex but these fields and relations are needed for that visual) :
https://drive.google.com/file/d/10VpjOCSx1eyqixI14mklcSlL-Cti0Y-e/view?usp=sharing
So I have field parameter to switch between the value fields (prmValueSelection) and a slicer for the Type in which user can select LBE1, LBE2, LBE3 etc.
The goal now is when 2 types are selected to get the difference in selected value of these two types.
(user should not select more then 2 but if he/she does result should just be blank, 0, error or whatever message)
I do not think it can be done but if somebody could find a way to achieve this that would be great.