Condition on a measure

Question

How to put a condition on a measure, I've a measure which have all numeric values in each row and need to compare it with a fixed number, I'm trying this:&nbsp;conditional_Column = IF(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;[Measure] &gt;= 20000 ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Met" ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Not Met"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )Please let me know if I'm doing wrong.Thanks

_aandrade · Answer

At fisrt glace, your measure is correct. If you can share a sample pbix, I can try to help you

anonymous · Answer

Hi,&nbsp;goldstain09&nbsp;
&nbsp;
According to your description, the MEASURE you wrote works, if he doesn't work in your DAX or you have other needs, you can share the pbix file with no sensitive data, the datasheet (not the screenshot), the desired effect, and the logic to achieve the effect.
&nbsp;

Best Regards,YangCommunity Support Team
&nbsp;
If there is any post&nbsp;helps, then please consider&nbsp;Accept it as the solution to help the other members find it more quickly.If I misunderstand your needs or you still have problems on it, please feel free to let us know.&nbsp;Thanks a lot!
How to get your questions answered quickly&nbsp;--&nbsp;&nbsp;How to provide sample data in the Power BI Forum

Forum Discussion

Condition on a measure

2 Replies

Related content

Conditional Measure

Measure Conditional formatting

Switch Measure - conditional formatting

Conditional Formatting Based on Measure

Create conditional measure