Column Based on Values From a Measure

[Chan]

Hi
All,

Need your help!!

I have Matrix report with the employee total score split by categories and need to add a calculated column based on the measure value. This measure comes from the selection of the slicers.

For Example Table: The Required score is calculated measure and below Pivot table have Total Score by each employee

I need to add a dynamic column to check each employee total score with the required score and work out whether that employee will have "full access" or "partial access".

Thank you in advance for your help!

[Nishantjain]

Have a look at the articles in the link below

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9dadbefd-e3c9-407f-8c60-d4a10f5e1ae4/dynami...

https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/

[v-frfei-msft]

Hi @Chan ,

Power bi not support dynamic calculate column based on slicer, you can use measure to instead the column and add the measure to visuals to work on it.

Regards,

Frank