Forum Discussion
Solved
Restricting Values for Total
Hi guys, I'm having some difficulties to have the totals on my report. I have a table which has several repeated rows, as the example bellow: Product - Value P1 - $500,00 P1 - $500,00 P1 -...
Hi adaocabelo,
Here I made an sample as your description. I created two measures to meet your requirement.
CA1L = MAX(opaRametro[Value])/CALCULATE(COUNT(opaRametro[Product]))
Measure = SUMX(opaRametro,[CA1L])
Then we can get the result as we excepted.
For more details, please check the pbix as attached.
https://www.dropbox.com/s/eakbjcoo32a90l6/Restricting%20Values%20for%20Total.pbix?dl=0
Regards,
Frank
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376