Forum Discussion

Hemanttripathi's avatar
Hemanttripathi
Regular Visitor
5 years ago

How to create condition column based on quick measure

Hello Power BI community,   I am struglling with one scenario where I have quick measure which subtracts two columns from two diffrent tables. Based on which i want to have one more column with res...
conditional column
New quick measure
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Hemanttripathi , Have new measure like

if([Quick Measure] >0 ,"Yes","No")

 

If need a column with a slicer then you need an independent table with ranges like

-99999999 0  , No

0.0000001 99999999 , yes

 

and then using Sr No level and this table you need to create a measure that you can use.

please refer to my video (Sample file link given in description)

https://www.youtube.com/watch?v=CuczXPj0N-k