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 Guys.
Need help with a calculated column.
I have the following calculated column. The idea is, if the scrap tyres have a value, then check whether all the other parameters have a value, if any one of them do, then "exclude tyres". I would like to use this as a filter:
What I am trying to achieve is, when I click exclude measure filter in my report, it should remove the tyres completely from the following measure:
It does not do so, because Oil disposed has a value (even though oil is not part of the second measure). Ideally the value for tyres should be "include" because metal, timber and general are all 0:
wrecking my brain trying to work this out.
Solved! Go to Solution.
Hi Guys.
So I had been able to do a workaround this. Had to pivot my main table. Although not ideal, but does the trick.
Hi Guys.
So I had been able to do a workaround this. Had to pivot my main table. Although not ideal, but does the trick.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
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 |
---|---|
95 | |
94 | |
80 | |
71 | |
64 |
User | Count |
---|---|
115 | |
106 | |
96 | |
81 | |
72 |