Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Variacion Porcentual

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!

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.