How to create condition column based on quick measure

[Hemanttripathi]

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 result if 'quick measure (DIFF)' ='0' then its 'yes' or else if less than or greter than zero it should be false.

The relationship between both the tables are based on Sr.No = 'Many to Many' as One to One is not possible to be created.

Here is the example two data set:

	DataSet_FDBA
Sr No	FDBA
1	100
2	1500
3	1500
4	200

	DataSet_ TBA
Sr No	TDBA	Quick Measure (DIFF)	Required column
1	90	10	No
2	1500	0	Yes
3	1400	100	No
4	200	0	Yes

Can anyone guide me how can i achieve the required column.

I am open for suggestions to redesign in order to achieve difference column and conditional yes or No column.

Thank you in advance.

Regards,

Hemant

[amitchandak]

@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