topic Re: IF statement output in DAX in DAX Commands and Tips

IF statement output in DAX

Anonymous — Wed, 11 Dec 2019 14:59:07 GMT

Hi All,

I have a dax query like below

Performace Status = IF((ISBLANK([Actual TD (Today)]) || ISBLANK([ Planned (Study) (EOM)])),0,1)

The above metric returns output correctly, but the problem comes in when I add dimensions.

EG:

When I add country getting correct output

Country	Performance Status
US	1

When i add product getting all product regardless of the fact output Which should return only one product A1, facing this issue when only with this metric since it uses if condition, where result returned for the note else if value too.. when i add the direct metric (Actual TD (Today) & Planned TD (Today)) used in this expression am getting i

Expected Output
Country	Product	Performance Status
US	A	1

Returned Output
Country	Product	Performance Status
US	A	1
US	A1	0

Re: IF statement output in DAX

Greg_Deckler — Wed, 11 Dec 2019 15:45:34 GMT

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.

Is that a measure?

Re: IF statement output in DAX

Anonymous — Wed, 11 Dec 2019 15:49:48 GMT

Yes it is a measure

Re: IF statement output in DAX

Anonymous — Fri, 13 Dec 2019 06:19:37 GMT

ADd meausre in Visual level filter and add condition MEasure is not 0.

Re: IF statement output in DAX

Anonymous — Fri, 13 Dec 2019 06:25:05 GMT

Its not about restricting the data, when i join the fact table with the country table, for US, It returns only one product A, but when i use the if statement it returns true correctly, but when it was false it returns all the values from the product table. So am trying to get the output only for the matched values of dimension table with fact table

Re: IF statement output in DAX

Anonymous — Fri, 13 Dec 2019 06:35:58 GMT

what is your exact requirement. Please be clear.