Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
ADd meausre in Visual level filter and add condition MEasure is not 0.
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
what is your exact requirement. Please be clear.
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?
Yes it is a measure
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
46 | |
31 | |
30 | |
18 | |
18 |