Variacion Porcentual

[Syndicate_Admin]

Hello!

I'm having trouble showing in a matrix a percentage variation I made with a measure.

He created the measure to be able to obtain the percentage variation between the total Revenue of a university against the Average Revenue of the conference. When I put this measurement in my matrix display, it shows the values as 0.00% and all of them like that.

I don't know if the measure is miscalculated, I don't know why this happens.

Thanks a lot!

[v-xinruzhu-msft]

Hi @Syndicate_Admin 

Can you provide the sample code of your measure, and based on your description, you want to calculate the total Revenue, you may need to use allselected() or all() function. you can refer to the following link about the following funciton.

ALL – DAX Guide

ALLSELECTED function (DAX) - DAX | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.