IF statement output in DAX

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

what is your exact requirement. Please be clear.

[Greg_Deckler]

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?

[Anonymous]

Yes it is a measure