DAX Measure not respecting filter context in powerBI visual

SilvandeGraaf — Tue, 02 Jul 2024 09:48:36 GMT

Context:

In Power BI, I want to create custom labels for my budget values. Currently, I'm using the following DAX measure:

label_Budget =
VAR BudgetAmount = [Budget_amount_total_no_Scope]
RETURN
CALCULATE(SWITCH(
TRUE(),
BudgetAmount > 0 && BudgetAmount < 1000, "€0",
BudgetAmount >= 1000 && BudgetAmount < 100000, "€0,.0K",
BudgetAmount >= 100000 && BudgetAmount < 1000000, "€0,.K",
BudgetAmount >= 1000000, "€0,,.#M") , ALLSELECTED())

My [Budget_amount_total_no_Scope] measure is defined as:

Budget_amount_total_no_Scope = SUM(daily_budget)

Issue:

The issue I'm facing is that the criteria in the label_Budget measure are applied to the total budget values, not per channel. As a result, a channel with a budget less than €1,000,000 gets the same label as a channel with a budget greater than €1,000,000 because the criteria are not applied individually to each channel.

Objective:

I want to modify my measure so that for every selected hierarchy level, the individual channel values are evaluated against the criteria in label_Budget.

Could someone help me adjust this measure so that it correctly applies the criteria at each individual channel level? Any guidance or suggestions would be greatly appreciated.

Re: DAX Measure not respecting filter context in powerBI visual

some_bih — Tue, 02 Jul 2024 10:37:11 GMT

Hi SilvandeGraaf without model and other details it is hard to provide possible solution.

Still, if you want to create and apply measure with all except logic, try using DAX function ALLEXCEPT on link

topic DAX Measure not respecting filter context in powerBI visual in DAX Commands and Tips

DAX Measure not respecting filter context in powerBI visual

Re: DAX Measure not respecting filter context in powerBI visual