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
Hi Greg, thanks for your reply.
This was very helpfull to change the total value, but I'm still getting same result as before.
Power BI is still adding all row on the total, instead of only the rows that appears.
Correct, because the total row executes in the context of ALL. For this to work, you need to calculate the total row in the context of ALLSELECTED.