Matrix Total

[Anonymous]

Hey guys!
Could anyone help me solve the problem of my Churn MRR % column total?

I am using the following measurement:

DIVIDE([Faturamento Perdido],

CALCULATE([MRR Ativo Real],

PREVIOUSMONTH('dCalendário'[Date])))

To arrive at this percentage measure I used other measures:

VAR FaturamentoPerdido = CALCULATE(

SUM('dClientes'[Valor_do_deal]),

'dClientes'[Status Clientes] = "Concluído",

'dClientes'[Data_fim] <> BLANK(),

USERELATIONSHIP('dClientes'[Data_fim], 'dCalendário'[Date]))

MRR Ativo Real =

([Faturamento Acumulado] - [Faturamento Perdido Acumulado])

This only happens when no month is selected

How could I resolve?

Thanks

[v-jingzhang · Accepted solution]

Hi @Anonymous

What is your expected result for the column total? There is PREVIOUSMONTH in the measure, so I think for the column total, it picks the last month from the current context to calculate the total value. 

"For total and subtotal rows, Power BI evaluates the measure over all rows in the underlying data – it isn't just a simple addition of the values in the visible or displayed rows. This means you can end up with different values in the total row than you might expect." See Understanding how Power BI calculates totals. 

Best Regards,
Community Support Team _ Jing

[Anonymous]

@v-jingzhang 
Yes, what you said makes a lot of sense. i think i was thinking wrong. Thanks so much