Forum Discussion
IF statement output in DAX
Hi All,
I have a dax query like below
| 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 |
5 Replies
- Greg_Deckler
Community Champion
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?
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
