Forum Discussion
andrejmfreitas
3 years agoHelper I
Conditional formatting in Power BI with calculation groups (for multiple measures at once)
Hello all, Imagine the following situation: I've created calculate items for multiple KPIs (TY, vs LY (%), vs Target (%)..etc). That works for all measures (Total orders, Total revenue..etc) I ...
Anonymous
3 years agoNot applicable
Hi andrejmfreitas,
Have you tried to use SELECTEDMEASURE function? As the document said, it will used by expressions for calculation items to reference the measure that is in context.
SELECTEDMEASURE function (DAX) - DAX | Microsoft Learn
Regards,
Xiaoxin Sheng
andrejmfreitas
3 years agoHelper I
Yes, I've tried.
PBI accepts the measure as "Correct". However, the conditional formatting does work. Therefore, none of these SELECTEDMEASURENAME or SELECTEDMEASURE works in a measure for Conditional formarting unfortuntely.
ChatGPT gave me some tips, but none of them worked either.
This would be a life-changer for advanced DAX development in my view.