Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago
Solved

Problems with The Visualization of a Measure With Percentage Variables

Good! [] The consultation is in order to better organize the measures. I have several measures to achieve a visualization and I want to group it into a single measurement. That is, I have severa...
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Syndicate_Admin 

     

    Sorry for the late reply. I misunderstood it previously. Please try this new measure. The updated pbix file is attached. 

    Measure 2 = 
VAR monthTotal = CALCULATE(SUM(Payments[Amount]),ALL(Payments[Customer]))
VAR customerTotal = SUM(Payments[Amount])
RETURN
DIVIDE(customerTotal,monthTotal)

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Thanks a lot!!
Logical solution and I was not seeing it, to continue learning!

Best regards.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi Syndicate_Admin 

 

You could experience ALL function a lot more. When using a column as a parameter in it instead of a table, the result is quite different. Besides, if my reply has solved this problem, could you accept it as solution? Thank you. 

 

Regards,

Jing