Forum Discussion
TOTAL ROWS IS WRONG
My total on the visual is wrong. How can i fix this? below is the formula that am using: Sales 80% = IF([Target Sales Achieve 80%]> SUM('Sales Main JO'[Actual Sales]),[Target Sales Achieve 80%]...
Please see this question as I believe it's solution will be similar to your needs: https://community.powerbi.com/t5/Desktop/Sum-of-values-in-a-measure-with-divide-measure/m-p/296768#M130947
HI jhartranft60 ,
I am not sure if i understood how to do it.
i tried that one but was giving me a wrong data.