Forum Discussion
help with calculated column
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.
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.
2 Replies
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-Forum/ba-p/963216
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/1447523Hi Guys.
So I had been able to do a workaround this. Had to pivot my main table. Although not ideal, but does the trick.
