Exclude Slicer filtered value in calculating Measure

[Anonymous]

Hi Power BI Experts,

I have a scenario to calculate 2 measures for revenue. user has option to select fiscal year from slicer.

For Example: user selected FY:2019 then i have to calculate show revenue values in table visualization.

Revenue FY:2019      Revenue Last FY: 2018

100                           50 (Expected value)  but showing blank

200                           30 (Expected value)  but showing blank

Here i'm able to create and show  measure values for Revenue FY:2019 with values. but for Last FY:2018 measure values are blank becuase table is already filtered with user selection FY 2019. so ideally it shows blank for last FY.

Any idea please guide me how to achieve my scenrio.

thanks,

Prasad

[v-yuta-msft · Accepted solution]

@Anonymous ,

---

For Example: user selected FY:2019 then i have to calculate show revenue values in table visualization.

Revenue FY:2019      Revenue Last FY: 2018

100                           50 (Expected value)  but showing blank

200                           30 (Expected value)  but showing blank

Here i'm able to create and show  measure values for Revenue FY:2019 with values. but for Last FY:2018 measure values are blank becuase table is already filtered with user selection FY 2019. so ideally it shows blank for last FY.

---

Basically you can add an ALL() statement to remove the filters from other tables or columns. You can also click Format-> Edit interactions then click the disable icon to disable the interactions between visuals. For more details, you may refer to: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.