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.
Attempting to use an if, then statement so that IF a column has a certain value then calcuated result will either return a "%" or text value that indicates "No number"
eg. If(sum(uplift cases)<1, "No Uplift", Divide( uplift cases,base cases,0))
The Dax measure returns the expected value if uplift is less than one the table column reads "No Uplift" and is uplift is 1 or higher it returns the % calculation from the Divide function.
ISSUE: when I filter customer (Using slicer) for a specific account the table returns ALL customers and not just slicer selection. I've tried wrapping in Calculate ALL SELECTED, SELECTED VALUE and also using VAR's. All patterns return expected result but all variations still return all Customers vs. just selected. Always appreciate the assistance.
Solved! Go to Solution.
Thanks for reviewing post... I think I found a solution. I put the If/then as a calculated column and then used that column in my table.
Now when customer is selected in slicer it only shows that customers.
Thanks, Spencer_II
@spencer_II
What is the relationship defined in the model?
Does your measure return Text and % ??.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks for responding///
Yes measure will return both Text and % value. The issue is when I filter the customer ALL customers show in table vs. just selected.
Customer from data table has a many to 1 relationship with Customers table and is SINGLE on cross filter direction.
@spencer_II
Not clear enough,
Can you share a sample PBIX file show me the expected behavior?
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Expected result:
Returned result:
Thanks for reviewing post... I think I found a solution. I put the If/then as a calculated column and then used that column in my table.
Now when customer is selected in slicer it only shows that customers.
Thanks, Spencer_II
Hi @spencer_II ,
Glad to hear the issue is solved. You can accept your reply as solution, that way, other community members could easily find the answer when they get same issues.
Best Regards,
Community Support Team _ Yingjie Li
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |