Group a table by some of its columns in a measure

[Damiax]

Hi everyone,

I'm here to ask you whether there's the possibility to create a measure by considering a table with just some of its columns.

Let's assume I have Table X, with column A,B, and C.

A and B are dimension, with A being the master dimension and B the subgroup. C is the column measure.

I need to develop Measure "Flag" over this table to see whether C is above a threshold, but not for the whole table, indeed just for "A" dimension.

Can i get rid of B dimension "virtually", just to take into account Dimension A in my measure?

Thanks,

Damiano

[v-kaiyue-msft]

Hi @Damiax ,

You can create a measure for evaluating whether the aggregated value C for each A is above a threshold. For this example, assume you have a threshold value of 200.

Flag_Above_Threshold =
CALCULATE(
IF([_sum_c] > 200, ‘Above Threshold’, ‘Below Threshold’),
ALLEXCEPT('Table', 'Table'[A])
)

In this measure, the ALLEXCEPT function is used to ignore all filters except the one applied to dimension A. As you requested, this effectively ‘gets rid’ of dimension B in the calculation, and more details can be found in the documentation: ALLEXCEPT function (DAX) - DAX | Microsoft Learn.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[Wilson_]

Damiax,

Short answer, almost certainly yes. Can you be more specific?