Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a slicer that I want to use to calculate an amount based on the selected slicer value:
So CG_Sel gives me the selected value and in this case 'Shipping Accuracy'.
Checked with a card, this works perfectly.
Now I want this name that comes out (Shipping Accuracy) to be used in this calculate function :
In the table UCL there is a field ShipGrp and it holds also the value Shipping Accuracy.
So thouht this would be pretty straight forward but DAX does not approve.
Anybody an idea how I could pass the outcome of the selected value as a filter for the calculate formula?
So telling that it should filter field ShipGrp on 'Shipping Accuracy'?
Solved! Go to Solution.
Ok...nevermind turns out that I cannot use the measure but I can use the logic that I created measure CG_Sel with....
This worked :
You can't use a measure in CALCULATE filter, it must be a boolean or table expressions
However, you can create a temporary varaible with VAR and RETURN like this
Please click Accept as Solution and the thumbs up button, thank you!
Answer =
VAR yourchoice = SELECTEDVALUE(yourtable[yourcolumn])
RETURN
CALCULATE(
SUM(yourtable[yourvalue],
yourtable[yourcolumn]) = yourchoice
)
You can't use a measure in CALCULATE filter, it must be a boolean or table expressions
However, you can create a temporary varaible with VAR and RETURN like this
Please click Accept as Solution and the thumbs up button, thank you!
Answer =
VAR yourchoice = SELECTEDVALUE(yourtable[yourcolumn])
RETURN
CALCULATE(
SUM(yourtable[yourvalue],
yourtable[yourcolumn]) = yourchoice
)
Ok...nevermind turns out that I cannot use the measure but I can use the logic that I created measure CG_Sel with....
This worked :
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
62 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |