topic Re: If statement doesn't work in DAX Commands and Tips

If statement doesn't work

elif — Tue, 22 Feb 2022 18:39:55 GMT

Hello,

I have a problem with IF statement which is not working perfectly, do you have any idea why it is not working very well?

is grater = VAR maxtable1 = CALCULATE(MAX('Date'[Date]),USERELATIONSHIP('Product'[NPI End Date],'Date'[Date])) VAR maxtable2 = CALCULATE(MAX('Product'[NPI End Date])) RETURN IF ( maxtable2 >= maxtable1, 1, 0)

POS Type NEW = IF([is grater] = 1, "NPI", 'Product'[POS type])

There is an inactive relationship between the Product'[NPI End Date] and Date'[Date]

Re: If statement doesn't work

amitchandak — Wed, 23 Feb 2022 06:14:33 GMT

elif , If this is a column, this will not work

POS Type NEW = IF([is grater] = 1, "NPI", 'Product'[POS type])

It needs to be a measure

example

POS Type NEW = IF([is grater] = 1, "NPI", max('Product'[POS type]) )

Re: If statement doesn't work

elif — Wed, 23 Feb 2022 15:53:22 GMT

Hi amitchandak

I tried both of them but still not working. When I try your suggestion it gives me just 2 Product Type but has to be 5 like Core Product, Identity, NPI, Custom, outofscope, and the NPI calculation is wrong as well.

Re: If statement doesn't work

amitchandak — Wed, 23 Feb 2022 15:58:44 GMT

elif , This will not work as column,

You have create a measure as, you are using measure in calculation

POS Type NEW = IF([is grater] = 1, "NPI", max('Product'[POS type]) )

Not get this working as a Column, you need an independent table(assume POS Type) with these two values. using a group by NPI name you need create a new measure to get this working

new Measure
Sumx(filter(Values(Table[MPI Name]), [POS Type NEW] = max(POS Type[POS Type])), [measure])

refer this blog or video for steps

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

Re: If statement doesn't work

v-yalanwu-msft — Fri, 25 Feb 2022 02:06:32 GMT

Hi, elif ;

Can you share a simple data removing sensitive information, along with the results you want to output?

It makes it easier to give you a solution.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: If statement doesn't work

v-yalanwu-msft — Wed, 02 Mar 2022 05:41:53 GMT

Hi, elif ;

Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,

Community Support Team_ Yalan Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.