Forum Discussion
Excluding a calculated column Explicitly from Column Totals
That should be possible.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Thank you for the sample file. It is slightly too big to attach it back here. Try creating a smaller version.
You have a lot of measures that are filtering the "All Programs" table. Yet that table is disconnected so these filters will have no effect on the data model. What you would need to do instead is to project the slicer choices onto the fact table via TREATAS - for that you would need to explain how PSC_Name maps into Actuals.
After that the formula would go something like this
updated sample I will try applying logic Thanks
