Forum Discussion
bars in visual not appearing properly
Hi Anonymous ,
Please try this measure to see if it matches the desired output.
2020-18 REF = DIVIDE ( SUM ( 'Total Sales 2018-21'[Sales 2020] ), SUMX ( ALLSELECTED ( 'Total Sales 2018-21' ), 'Total Sales 2018-21'[Sales 2020] ) ) - DIVIDE ( SUM ( 'Total Sales 2018-21'[Sales 2018] ), SUMX ( ALLSELECTED ( 'Total Sales 2018-21' ), 'Total Sales 2018-21'[Sales 2018] ) )If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi Anonymous ,
Please try this measure to see if it matches the desired output.
2020-18 REF =
DIVIDE (
SUM ( 'Total Sales 2018-21'[Sales 2020] ),
SUMX (
ALLSELECTED ( 'Total Sales 2018-21' ),
'Total Sales 2018-21'[Sales 2020]
)
)
- DIVIDE (
SUM ( 'Total Sales 2018-21'[Sales 2018] ),
SUMX (
ALLSELECTED ( 'Total Sales 2018-21' ),
'Total Sales 2018-21'[Sales 2018]
)
)
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-kkf-msft ,
This is the correct formula!
I can't tell you how glad I am!
Thx a million for your kindness and for the opportunity for me to learn something new!
The ALL functions have been on my study agenda, just didn't get to them yet. But now I am going to delve into them.
Thx for your great help and have a great day!
Attila