Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a table with 3 columns :
I want to set up a Pivot Table with :
What is the DAX formula for Measure2 ?
Thanks
Regards
Measure 2 =
var L=selectedvalue(table[Level])
return calculate(sum(Table[quantity]),table[Level]=L+1)
It works fine ! Thanks
Before asking on the forum, I tried SELECTEDVALUE but I put it in the CALCULATE expression, and it did not work.
So, The solution seems to use SELECTEDVALUE in a VAR expression...
Regards
If you want to attain the same behaviour without variables then you will have to use explicit FILTER, for example.
Measure =
CALCULATE (
[Total Sales],
FILTER (
ALL ( Product[Brand] ),
Product[Brand] = SELECTEDVALUE ( Product[Brand] )
)
)
Because writing aggregation functions like SUM, AVERAGE, MAX are not allowed while doing boolean filter operations, and same is for SELECTEDVALUE, hence the following won't work.
Measure =
CALCULATE (
[Total Sales],
'Product'[Brand] = SELECTEDVALUE ( 'Product'[Brand] )
)
There's also the added complexity with FILTER (ALL()) - that may produce more results than intended in the visual context.
Correct, in that case he can either wrap CALCULATE's filter arguments with KEEPFILTERS or use VALUES as per the requirements.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |