Ignoring the slicer in measure

[Anonymous]

I am building a test/control dashboard.

I have pre/post-test and pre/post control. The Visuals for the Control are disconnected from the slicers so they always show the same growth.

If there is nothing selected in my slicers I get all the correct numbers. When I slice, it filters my control measure but I don't want it to.

Here is an example

Overall Test is 20 post, 10 pre so 100% growth

Control is 15 post, 10 pre so 50% growth.

The change is 100-50 so 50%.

Now I want to look at a specific store. That store was 6 post, 4 pre, so 50% growth.

I want me difference measure to still to 50-50 so 0. Instead, my control 0s out and it still shows 50.

Can someone help me with Dax that will ignore the slicer values? Thanks
I tried the below query, but it doesn't display the correct output.

_inc_exams_test_ctrl = (((7 *

CALCULATE(AVERAGE(Tele_Health[Qtyexamcompre]),FILTER(Tele_Health,AND(Tele_Health[Period] = "Post-Period",Tele_Health[Store_Type] = "Test Store"))))/CALCULATE(AVERAGE(Tele_Health[Avg_Pre_Exams]),FILTER(Tele_Health,Tele_Health[Store_Type] = "Test Store")))-1)

-

(((7 *

CALCULATE(AVERAGE(Tele_Health[QtyExamCompre]),FILTER(Tele_Health,AND(Tele_Health[PERIOD] = "Post-Period", Tele_Health[Store_Type] = "Control Store")),REMOVEFILTERS(Tele_Health[storenumber]))/

CALCULATE(AVERAGE(Tele_Health[Avg_pre_Exams_CONTROL]),FILTER(Tele_Health,Tele_Health[Store_Type] = "Control Store"),REMOVEFILTERS(Tele_Health[storenumber])))-1))

[ahmedoye · Accepted solution]

@Anonymous , becuase you measure is very long, you can just write a new one that is like
Final Measure = CALCULATE(_inc_exams_test_ctrl ,
                                             REMOVEFILTER(TheColumnInTheSlicer))

[ahmedoye · Accepted solution]

@Anonymous , becuase you measure is very long, you can just write a new one that is like
Final Measure = CALCULATE(_inc_exams_test_ctrl ,
                                             REMOVEFILTER(TheColumnInTheSlicer))

[Anonymous · Accepted solution]

Thank you so much Ahmed. It worked like a charm. 

[Anonymous]

If you want a measure to ignore slicers you need to use the ALL and its family of functions within your calculate statement.