Forum Discussion
Select item from slicer by coding
How can select an item from slicer by coding?
Thanks
Hello Dreamer_Argento ,
If you want that certain measure is forced to certain selection you can use as calculate modifier.
For example if you have measure: Sum('orders'[Salesamount])
You can force it the certain selection for example:Calculate(Sum('orders'[Salesamount]),'customer'[Customer Name]="Microsoft")
Other option is to force visuals that use the measure as visual filtter
Choose the selections and lock it
Hope this helps!
4 Replies
Hello Dreamer_Argento ,
If you want that certain measure is forced to certain selection you can use as calculate modifier.
For example if you have measure: Sum('orders'[Salesamount])
You can force it the certain selection for example:Calculate(Sum('orders'[Salesamount]),'customer'[Customer Name]="Microsoft")
Other option is to force visuals that use the measure as visual filtter
Choose the selections and lock it
Hope this helps!Dreamer_Argento , you mean get selected value from slicer in code and use it further?
Dear ERD I want to select a value using Dax simulating a user clicking on a slicer.
Dreamer_Argento , well, if you mean some particular value, it could be something like
...
DimProducts[Category] = "Beverage"
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
