Forum Discussion

Helper I

5 years ago

KEEP TOTAL NO DATA RELATED

Hello, Anyone could help me? I have a measure that brings me values based on another column of the same table (A). When I add a field from another table (B) it shows only the values that has data ...

Community Champion

5 years ago

Do you have a sample pbix that you can share (remove sensitive data)?

"Total" on a table/matrix is not a SUM of all of the rows in the table - it is the measure calculated in the "Total" context, which may have some different filters than you realize. Odds are 1 is correct and we just need to figure out what is affecting the filter context on your "Total" row.

David

r_fioretti

Helper I

5 years ago

Hello,

Thank you for your reply. I’m sorry for the delay but I couldn’t do it promptly.

Attached is a file with the sensitive data removed. I’ve changed some data to try to keep the report as near as possible of the original one.
The problem with persist in the totals.

PS: I can’t upload the file. Following a link to a shared version on Dropbox.

Regards.

https://www.dropbox.com/s/c9znx6476ealj80/Sample.pbix?dl=0