Totals for Matrix or Table

[Anonymous]

Hi Everyone, above is an example of my schema and current results when trying to display the "Totals" for my data. I am unable to see the totals for either my table or matrix (with a drill down). Can anyone please assist me? 

Thanks!

[MFelix]

Hi @Anonymous,

This as to do with the cross filtering you have, from what I can tell from the image you have several relationships between your tables with cross filter.

Please check this: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

The results with cross filter aren't always as expected if we don't have the correct setup. As @TomMartens said can you please share some sample of data and expected results.

Regards,

MFelix

[Anonymous · Accepted solution]

Hi @MFelix - Thanks for reaching out. I fixed my issue. I thought it was a crossfiltering problem as well.

Something I forgot to add to the picture above is that I also had a OS table with a score.

So, my goal was to have a total score. I created a column in the Applications table that calculated the scores of the related tables (OS and DB) . When I added this total score to the matrix it wasn't adding. However, when I added it to the host level it worked. 

[TomMartens]

Hey,

I'm wondering about the data type of your column Risk Score.

Mark the column in the fields pane and check the data type from the Modeling menu:

Maybe you just have to change the data type to a numeric data type.

Regards

Tom

[Anonymous]

Hi Tom - The value is a whole number. Not sure why it isn't adding my values. 

[TomMartens]

This is odd, can you please share a pbix with some sample data.

Regards

Tom

[Anonymous]

@TomMartens Hi Tom- Thanks for reaching out. I fixed my issue. 

Something I forgot to add to the picture above is that I also had a OS table with a score.

So, my goal was to have a total score. I created a column in the Applications table that calculated the scores of the related tables (OS and DB) . When I added this total score to the matrix it wasn't adding. However, when I added it to the host level it worked.