Forum Discussion
PGM % help
We are converting from Tableau to Power BI. I have a PGM% calc in Tableau = sum(PGM Numerator)/sum(PGM Denominator) where the numerator is PGM and the denominator is sales that will use the filters i...
I figured it out. No further work required!!
Hello
Bridges Live Scale = round(IF(HASONEVALUE(Scale[Scale]),SUM('Bridges Base Data'[Amount Correct Sign])/VALUES(Scale[Scale]),SUM('Bridges Base Data'[Amount Correct Sign])),2)
Scale = Thousands or millions
The category can be in the filter. I was troubleshooting so I put it in the measure. The only filter we need in the calc is the reportline Sales for the one and PGM for the other. I can get those numbers but when I divide them, I get nothing.
I figured it out. No further work required!!