topic Re: If Column >< or = 0 in DAX Commands and Tips

If Column >< or = 0

sdhn — Tue, 04 Jan 2022 16:23:40 GMT

Hello All,

I have a spread sheet. I need to create calculate column for E, H & I columns in Power Bi. So my source spreadsheet will be without E, H & I columns.

I like to calculate all columns through Power Bi.

For Column E formula in Spread sheet is as: =IF(D2<=0,"N/A",(C2/D2))

For Column H formula in Spread sheet is as: =IF(D2>0,SUM(F2:G2),0)

For Column I formula in Spread sheet is as: =IF(H2>0,(H2/D2),"N/A")

A	B	C	D	E	F	G	H	I	J
A1	32	29	61	47.5%	6.26	133.91	140.17	2.298	APRIL 2021
B1	72	0	72	0.0%	0.99	84.16	85.15	1.183	APRIL 2021

Help will be appreciated. Thanks

Re: If Column >< or = 0

smpa01 — Tue, 04 Jan 2022 16:31:25 GMT

sdhn calculated column in dax

E = IF('Table'[D]<=0,0,DIVIDE('Table'[C],'Table'[D])) H = IF('Table'[D]<=0,0,DIVIDE('Table'[C],'Table'[D])) I = IF('Table'[H]>0,DIVIDE('Table'[H],'Table'[D]),0)

Re: If Column >< or = 0

sdhn — Tue, 04 Jan 2022 16:47:03 GMT

Hi Smpa01,

Thanks for prompt response.

For column E & I works fine.

But look at formula of col. H

Column Name : Total Amount (H)

=IF(D2>0,SUM(F2:G2),0)

Its requires sum of F2:G2. isn't?

you suggested as:

H = IF('Table'[D]<=0,0,DIVIDE('Table'[C],'Table'[D]))

Please advice. Thank you

Re: If Column >< or = 0

smpa01 — Tue, 04 Jan 2022 16:49:04 GMT

sdhn

_H = IF('Table'[D]>0,'Table'[F]+'Table'[G],0)

Re: If Column >< or = 0

sdhn — Tue, 04 Jan 2022 17:15:31 GMT

H = IF('Table'[D]>0,'Table'[F]+'Table'[G],0)

I am getting following message:

<pi>A circular dependency was detected: TABLE[Column], TABLE[Column E], TABLE[Column].</pi>

We created Column E earlier as:

E = IF('Table'[D]<=0,0,DIVIDE('Table'[C],'Table'[D]))

Thanks

Re: If Column >< or = 0

smpa01 — Tue, 04 Jan 2022 17:18:34 GMT

sdhn take a look here

Re: If Column >< or = 0

sdhn — Tue, 04 Jan 2022 17:47:20 GMT

Is it possible , I can send you a sample source file?

Still not working for me. Thanks

Re: If Column >< or = 0

smpa01 — Tue, 04 Jan 2022 17:48:42 GMT

sdhn yes