Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 in the report to calculate the %. I can't seem to get this to work in Power BI.
Solved! Go to Solution.
@Anonymous , 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.
I figured it out. No further work required!!
Here is a pic of our Bridges Base Data. We use the Report Line Code to pick the Sales and PGM.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |