Forum Discussion
AdministratorProblems with The Visualization of a Measure With Percentage Variables
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.
AdministratorGood!
I took the time to do it as it is by creating a "Year-Month" column even.
I still don't see the expected result.
I do not achieve that per month the % per Client represents the total of 100%.
Best regards.
Community Support
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
Thanks a lot!!
Logical solution and I was not seeing it, to continue learning!
Best regards.- v-jingzhang
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