Showing results for 
Search instead for 
Did you mean: 
Not applicable

Derived Column to have values according to the measure

Hey Guys,


Is there a chance I can set the value of a derived column to be according to the value of the measure?

Basically I have a numeric measure (0,1,2,3 and greater than 3) and I need the derived column to have values "=0", "=1", "=2", "=3" and ">3" accordingly. I tried doing so with this formula but it doesn't work 😞


Quantity = IF(SUM(Table[Reopenings])=0, "=0", IF(SUM(Table[Reopenings])=1, "=1", IF(SUM(Table[Reopenings])=2, "=2", IF(SUM(Table[Reopenings])=3, "=3", ">3"))))

Does anyone have any idea on how can I do this?


Thanks a lot!


Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.