Forum Discussion
Variance /slicer dependent/ need help for the formula
Hi TCGH ,
If you select multiple plans in one slicer, you can't locate the one you selected.
As you can see, below both of these scribing formulas are the same, the computer doesn't recognize the first selected plan you are talking about, and the second plan.
You have to create two tables like I did to implement your first slicer's choice and second slicer's choice, and the two slicers were not related to each other.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi TCGH ,
If you want to compare the values of two slicers, it's a good idea to have fields from two different tables, and the tables of the two slicers are not related to your main table.
Here's an example for reference:
Measure = var _sel1=SELECTEDVALUE(Slicer1[Criteria])
var _sel2=SELECTEDVALUE('Slicer2'[Criteria])
return CALCULATE(SUM('Table'[Volumes]),FILTER('Table',[Criteria]=_sel1))-CALCULATE(SUM('Table'[Volumes]),FILTER('Table',[Criteria]=_sel2))
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Stephen
We are getting somewhere.
I used your formula (without creating slicers in the table). By using one slicer from the Visualizations with multiple choice.
I updated the formula with the names of the table and data:MeasureVARSPP = var _sel1=SELECTEDVALUE(PRODUCTION[Plan])var _sel2=SELECTEDVALUE(PRODUCTION[Plan])return CALCULATE(SUM('PRODUCTION'[Volumes]),FILTER('PRODUCTION',[Plan]=_sel1))+CALCULATE(SUM('PRODUCTION'[Volumes]),FILTER('PRODUCTION',[Plan]=_sel2))Whereas when I select 2 Plans in the slicer, I get the following:Plan 1 Plan 2 Plan Total Prod Volum MeasureVARSPP Prod Volum MeasureVARSPP Prod Volum MeasureVARSPP 10000 0 12000 0 22000 0 20000 0 16000 0 36000 0 I changed the minus into + in the formula and got this:
Plan 1 Plan 2 Plan Total Prod Volum MeasureVARSPP Prod Volum MeasureVARSPP Prod Volum MeasureVARSPP 10000 20000 12000 24000 22000 0 20000 40000 16000 32000 36000 0 Strangely, it is not showing me the variance, in both cases.
It is only adding up and in the second case it shows a measure that is double (probably due to +) and the total stays a double.Hi TCGH ,
If you select multiple plans in one slicer, you can't locate the one you selected.
As you can see, below both of these scribing formulas are the same, the computer doesn't recognize the first selected plan you are talking about, and the second plan.
You have to create two tables like I did to implement your first slicer's choice and second slicer's choice, and the two slicers were not related to each other.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
