Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear community,
This seems like an easy-fix, but I am not able to come up with how to deal with this issue.
I have a fact table (let's call it [f_Sales]).
In this table is a column. Let's call it [SalesCategory]. Let's say that the values in this column are {A, B, C, D, E....}
Now, in my report, I have a slicer on the report page with [SalesCategory]. I need this slicer for some of the KPIs on the report page.
My issue is that I need to create a measure that completely ignores what selections are made on the slicer, but always applies [SalesCategory] = A or B.
I need your support how to write such measure.
I have tried almost everything that I can think of (ALL, ALLEXCEPT, REMOVEFILTERS..) but I am not able to produce a measure that ignores this slicer.
No matter what I try, the slicer is always affecting the measure. (For instance, if I select all categories it will show all categories. If I select categories C-E it will show zero and if I only select category A or B it will show only that category).
I also cannot just use "Edit interactions" on that visual because I need other measures in the same visual to actually comply with the slicer.
Please help!
Rasmus
Solved! Go to Solution.
Please Try this measure.
SalesCategory=
CALCULATE(
[YourKPI],
FILTER(
ALL('f_Sales'[SalesCategory]), 'f_Sales'[SalesCategory] IN {"A", "B"}
)
)
Please Try this measure.
SalesCategory=
CALCULATE(
[YourKPI],
FILTER(
ALL('f_Sales'[SalesCategory]), 'f_Sales'[SalesCategory] IN {"A", "B"}
)
)
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
62 |