Forum Discussion
PGM % help
I figured it out. No further work required!!
Super UserAnonymous , measure [Bridges Live Scale] should be sum measure. Category and Report Line for Reporting do not have other filters on-page or visual
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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.
Here is a pic of our Bridges Base Data. We use the Report Line Code to pick the Sales and PGM.
I figured it out. No further work required!!