Solved: Variation of 2 running totals - Page 2

DM_BI · ‎10-29-2018

Hello,

I have 2 measures (calculated with the quick measure Running Total) :
- Real acum (which is the running total of my sales, what really was sold)

- Objetivo acum (which is the running toal of the objective we should do)

Now I want to know the variation between these 2 measures, to see if I am reaching my goal or not. So what I did was :

Var acum % = DIVIDE(('OBJ PI'[Real acum]-'OBJ PI'[Objectivo acum]);'OBJ PI'[Objectivo acum];0)

But I get the exact same result as the variation between my Real and my Objective. I mean, what I got was that my "normal" variation equals my "cumulative" variation, which is not true.

Anyone can help me with this?

Thank you!

D.

v-shex-msft · ‎11-08-2018

Hi @DM_BI,

After play with you sample, I found you can remove column defined in allselected function to get correct result value:

FACTURATION running total in MONTH = 
CALCULATE(
	SUM('Hoja1'[FACTURATION]),
	FILTER(
		ALLSELECTED('Hoja1'),
		ISONORAFTER('Hoja1'[MONTH], MAX('Hoja1'[MONTH]), DESC)
	)
)


OBJECTIVE FACTURATION running total in MONTH = 
CALCULATE(
	SUM('Hoja1'[OBJECTIVE FACTURATION]),
	FILTER(
		ALLSELECTED('Hoja1'),
		ISONORAFTER('Hoja1'[MONTH], MAX('Hoja1'[MONTH]), DESC)
	)
)

BTW, you can't create dynamic calculated column based on slicer/filter or dynamic measure.(when you use measure in calculate column measure result will been fix)

Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Variation of 2 running totals

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly