Forum Discussion
Dynamic percentage based on attributes applied
Ok great, the formatting must have been the elusive element.
Doing some quick maths:
208764.42 / 37968039.17 = 0.005498425. As a percentage that should be 0.54%. So that means you are correct in that its 100 times too small, plus the number itself is wrong.
Lets create 2 more measures.Numerator = SUM('YourTable'[SumActualCost]) Denominator = SUM('YourTable'[Total Cost])Bring those into the matix next. I'm curious what that comes up with.
For the reason the reason it doesn't add to 100%, i believe My error is with Total Cost. Instead of SUM for the Denominator, we should use MAX instead. This is because you don't actually want to sum up that column.
No definately not, thats not necessary. Does your formula now look like?
Simple % = DIVIDE( [Numerator], [Denominator] )Remembering Numerator and Denominator are measures, so we can call them directly in our new Measure.
The slicers you are using, are they from the same table as the data or are the slicers referencing another table? Is the table relationships correct to enable your slicers to work?
In the original file (with multiple tables and transformations) the slicer is from the same table as the measures. In the new file there is only one table and no transformations - so the slicer is from the same table as the measures again.
The formula used for Total Cost is:
Original file (where the table has been grouped): Total Cost = SUM('AssignmentTPDS'[SumActualCost])
New file (where the table hasn't been grouped): Total Cost = SUM('Query1'[AssignmentActualCost])
Anonymous - have you had anymore thoughts on this?
Sorry Anonymous no I haven't. As described, it should work. Based on everything you have put forward, it should work. There must be another unseen element at play.