Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a list of monthly values per items for cost and sales and a helper column that indicates with a ! if the given months is overspend(negative).I use this to count the number of months that the items are overspend.I would like to present this value as a % of the total months ( months negative + months Positive) Is there a way to do this.
My idea was to create a grouping of the two to get the total but I cant set the values for months negative as a % of the grouping.If I set it as a % of total is calculates it for the overall total not just not just the item in question
Solved! Go to Solution.
You should be able to do a calculation with a FILTER of the helper column = "!" and another with a FILTER of the helper column <> "!". Basically, wrap your calculation in a CALCULATE and add the correct FILTER statement.
You should be able to do a calculation with a FILTER of the helper column = "!" and another with a FILTER of the helper column <> "!". Basically, wrap your calculation in a CALCULATE and add the correct FILTER statement.
Thanks for the reply let me look into it and see if I can make it work
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |