Forum Discussion

vedantsri's avatar
vedantsri
Icon for Helper I rankHelper I
3 years ago

How to apply a different measure based on column value?

Hi All,   I have a table that looks like this: Office Tier A High B Mid C Mid D Low   Office column is a distinct column.   Now I wanted to calculate Demand (Which is co...
Need Help
KNP's avatar
KNP
Icon for Super User rankSuper User
3 years ago

Am I correct in assuming this is your numbering for tier in the measures? 

 

 

KNP's avatar
KNP
Icon for Super User rankSuper User
3 years ago

vedantsri,

 

Above I made an assumption about the numbering of low, medium, high and added a column to the Office table in Power Query.

If this is incorrect I'll need to update.

 

Attached is a very basic PBIX file using your sample data, altered slightly to ensure one crosses the threshold.

Have a look and see how close the measure called 'Measure' is, to what you're looking for?