percentage of grand total

[christianfcbmx]

Im using this and it works perfect: DIVIDE(SUM(Vista_TGT[Cantidad]), CALCULATE(SUM(Vista_TGT[Cantidad]), ALL(Vista_TGT[Expr3])))

So Im getting the percentage right

But I need the same dax but this time with the PREVIOUSYEAR function...I tried this  and didnt work: DIVIDE(SUM(Vista_TGT[Cantidad]),CALCULATE(SUM(Vista_TGT[Cantidad])),PREVIOUSYEAR(Vista_TGT[Fecha]),ALL(Vista_TGT[Expr3]))

Any idea how to fix it?

I would really appreciate your guys  help or advices!!!!!!!

[v-chuncz-msft · Accepted solution]

@christianfcbmx,

You may add another measure as shown below.

Measure 2 =
CALCULATE ( [Measure], PREVIOUSYEAR ( Vista_TGT[Fecha] ) )

[Zubair_Muhammad]

HI @christianfcbmx

I believe you need SAMEPERIODLASTYEAR.

Try replacing PREVIOUSYEAR with SAMEPERIODLASTYEAR

[christianfcbmx]

Didnt Work 😞