Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |