Forum Discussion

ggmm17's avatar
ggmm17
Frequent Visitor
1 year ago

Dynamic Currency Display in Filter

I have a currency filter where the user will select which currency to use to run the report however,  If the scenario selected is 1, the only currency that will display is Euros If the scenario sel...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks for the reply from DataNinja777 , please allow me to provide another insight: 
Hi  ggmm17 ,

I created some data:

Here are the steps you can follow：

1. Create a table of computed distinct entity columns with no joins as a slicer..

entity slicer table =
DISTINCT('entity tables'[entity])

2. Create measure.

Measure =
var _selectcurrency=SELECTEDVALUE('scenario table'[scenario currency])
var _selectentity=SELECTEDVALUE('entity slicer table'[entity])
RETURN
SWITCH(
    TRUE(),
    _selectcurrency=1 && MAX('entity tables'[currency])= "Euros",SUM('entity tables'[Value]),
    OR(_selectcurrency=2 , _selectcurrency= BLANK()) && MAX('entity tables'[entity])=_selectentity ,SUM('entity tables'[Value]))

3. Result:

Slicer – blank:

Slicer – 1:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly