Forum Discussion
Removing a running total
Hi,
I was wondering, whether it was possible to remove a measure without inflicting another.
Currently, I have made two running totals. One which calculates the "total hours spent" each month and another which calculates number of employees (also running totals). These two measures are used to see how many hours are spent compared to the numbers of employees in a third measure. However, I would like to delete the measure "total hours spent", which is not possible as, the visualization will fail then.
Does anyone have any suggestion?
2 Replies
HI Anonymous
Do you mean to delete the measure from a visual, or from the model all together?
You can always save a copy of your PBIX file as a "before", then delete your measure and if everything is ok and there are no dependencies, you don't need to revert to the "before" version.
Hi Phil_Seamark
From the visual, not the measure. I have two running totals here named "løbende". The "prognose"-measure is based on Årsværk / antal virksomhedstimer løbende sum and I cannot delete the "antal virksomhedstimer løbende sum" as I get an error then.
