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.
I have a report filter to exclude all data that has and [Item Status] of Cancelled. However I want one calculation to exclude this parameter. I want it to callculate the sume of my $$ even if it is cancelled. I have created the measure below:
measure = CALCULATE(SUM(factPPM[Currency Amount (Fin Plan)]), all('Forecast Period'), ALL(dimLists[Item Status]), factPPM[Financial View (Fin Plan)]="Budget")
However, the result of this measure is still affected by the report filter. Im not sure how else to make this calculation not be affected.
Can anyone provide some suggestions?
Thank you in advance for your help.
Hi @Anonymous ,
Please describe your problem with sample data and show the expected result. How to Get Your Question Answered Quickly
If possible, you could share the sample .pbix file where sensitive data is masked.
Regards,
Yuliana Gu
@Anonymous
Hazarding a guess: Do you have a "sort by" column set for dimLists[Item Status]?
If so, you will also need to include that column in ALL.
See this article:
https://www.sqlbi.com/articles/side-effects-in-dax-of-the-sort-by-column-setting/
Hmm, I can't seem to replicate this. I created a measure like:
Measure 11 = VAR __table = ALL(Table14[Prod Order No_]) VAR __values = DISTINCT(__table) RETURN CONCATENATEX(__values,[Prod Order No_],",")
And even if I put in a Report filter excluding some of these, this measure returns all of them.
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |