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 want to lock a Year = 2014 measure
I have tried two measures
Sales2014b = SUMX( FILTER( (InvLines), RELATED(InvHeader[Year] ) = 2014), ( InvLines[SalesValue]))
and
Sales2014 = if (related(InvHeader[Year]) = 2014 , InvLines[Invoiced Quantity] * InvLines[OrderPrice] * (1 - InvLines[Line Discount %]) * (1- RELATED(InvHeader[Invoice Discount %])))
Both give the same correct result. But when I filter Year = 2013 it blanks the 2014 column out. I want to keep this value but only exclude this one filer. All the other filters should apply.
Qlik can do this using set analysis but I just can not work out how to do it in Power BI. I've tried "all" and it didn't work
Thanks for any assistance
Solved! Go to Solution.
ok
This seems to work
Sales14 = CALCULATE(sum (InvLines[SalesValue]), InvHeader[Year] = 2014)
ok
This seems to work
Sales14 = CALCULATE(sum (InvLines[SalesValue]), InvHeader[Year] = 2014)
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 |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |