Forum Discussion
Solved
Need help in All Function
Hi All, I am getting blank dimension value automatically when i use ALL function. Can anyone please help? I do not want this blank getting assigned in 'Total Sales'. Total Sales= CALCULATE...
Hi jibran_wani ,
Based on the information you provided, these table columns must not be from the same table. Refer to below table relationship and formula:
Total Sales = CALCULATE(SUM(Pro[Net Sales]), ALL('Pro'))Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi jibran_wani ,
Based on the information you provided, these table columns must not be from the same table. Refer to below table relationship and formula:
Total Sales = CALCULATE(SUM(Pro[Net Sales]), ALL('Pro'))
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.