Average just one item in a column table

[AlbertoChirinos]

Hi everyone,

I am relatively new working on Power Bi and I am struggling with a measure I want to create. I have below table with different measures created for monthly, year to date, full year, past year and so on. But the issue is that I have one item in the column Unit of Measure called M2 which is summing just as the others, but in fact this item should not be summing it should be an average and I don't know how to create a measure that sum for the rest of items but average just for this one.

Hope you can help me on this one.

Thanks.

[daXtreme · Accepted solution]

@AlbertoChirinos 

In your measure just use SWITCH on the unit of measure field. Your measure must sense if the relevant unit of measure is in scope and then apply the different logic. To check if it's in scope you can either use the ISINSCOPE function or HASONEFILTER (perhaps with some additional conditions).