Ignore Slicer

[Manuel123]

Dear all,

I hope you can help me. I tried to find a solution first but I don't get along with ALL, ALLEXCEPT and changing the interaction of slicers and visuals does not help me a lot. I'm sure that I do somethong wrong, but I just don't know what.

I have a fact table:

Date	BaseCase	Scenario	Fact
31.09.2021	Budget	Budget	1
31.10.2021	Budget	Budget	2
31.09.2021	FC	FC	1
31.10.2021	FC	FC	2
31.09.2021	FC	FC-New	3
31.10.2021	FC	FC-New	4

I have a Bar-Chart to compare values and a slicer for "BaseCase" and one for "Scenario". Now I would like to calculate two Measures:

1) FC = Values based on the Slicer

2) Budget = Values where BaseCase = Budget and Scenario = Budget, independently what is chosen in the slicer

Then I'd like to show FC and Budget in the Bar-Chart.

I thought this could be solved by 

FC = CALCULATE(SUM([Value]),USERELATIONSHIP(Date in FactTable,Date in DateTable))

and

Budget = CALCULATE(SUM(Value),REMOVEFILTERS([BaseCase],[Scenario]),FILTER(FactTable,BaseCase="Budget"),FILTER(FactTable,Scenario="Budget"))

However, that does not work. I only see the Budget values when I select the Budget-Scenario in the Scenario-Slicer.

I hope that you can help me.

Best regards and thank you in advance

Manuel

[parry2k · Accepted solution]

@Manuel123 check my blog post here which talks the similar scenario Compare Budgeted Scenarios vs. Actuals | PeryTUS IT Solutions

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡