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
DPL Revenue = CALCULATE(sum('DPLImportPBI'[Forecast Revenue]),filter('DPLImportPBI',DPLImportPBI[IsLastestSubmissionValue]="Yes"))
Fo the above measure I want it to ignore a slicer on the page of the report. The Slicer is for a column called "Submission"
I have tried the following and it does not work
DPL Revenue = CALCULATE(sum('DPLImportPBI'[Forecast Revenue]),filter('DPLImportPBI',DPLImportPBI[IsLastestSubmissionValue]="Yes"),all('DPLImportPBI'[Submission]))
The above attempt does not work. The measure still changes with the slicer
Solved! Go to Solution.
Hi @Anonymous,
My mistake.
Based on my test, the formula below should work in your scenario.
DPL Revenue = CALCULATE ( SUM ( 'DPLImportPBI'[Forecast Revenue] ), ALL ( 'DPLImportPBI'[Submission] ), DPLImportPBI[IsLastestSubmissionValue] = "Yes" )
Regards
Please note below also does not work.... the measure still changes it result when making slicer selections for the Submission column
DPL Revenue v2 = CALCULATE(sum('DPLImportPBI (2)'[Forecast Revenue]),filter('DPLImportPBI (2)','DPLImportPBI (2)'[IsLastestSubmissionValue]="Yes"),ALLEXCEPT('DPLImportPBI (2)','DPLImportPBI (2)'[Submission]))
Hi @Anonymous,
Could you try the formula below to see if it works in your scenario?
DPL Revenue = CALCULATE ( SUM ( 'DPLImportPBI'[Forecast Revenue] ), FILTER ( ALL ( 'DPLImportPBI'[Submission] ), DPLImportPBI[IsLastestSubmissionValue] = "Yes" ) )
Regards
That errors out from where I highlighte in red.... Note IsLastestSubmissionvalue is a column with yes/no data its not a measure.
DPL Revenue = CALCULATE ( SUM ( 'DPLImportPBI'[Forecast Revenue] ), FILTER ( ALL ( 'DPLImportPBI'[Submission] ), DPLImportPBI[IsLastestSubmissionValue] = "Yes"
Hi @Anonymous,
My mistake.
Based on my test, the formula below should work in your scenario.
DPL Revenue = CALCULATE ( SUM ( 'DPLImportPBI'[Forecast Revenue] ), ALL ( 'DPLImportPBI'[Submission] ), DPLImportPBI[IsLastestSubmissionValue] = "Yes" )
Regards
Looks like that is working.... thanks
I have a few other measure where I need to replicate this solution
thanks again
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |