Forum Discussion
Dynamic percentage based on attributes applied
Hi
I created a new file with only the main table, without any transformations made to it. I added the measures and the same thing still happens. When a slicer is applied, the percentages don't recalculate to show the ratio within that selection. It appears to be hard-coded to the overall total cost rather than being dynamic. Is there a change I could try to the measures formulae?
Thanks
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.