Forum Discussion
Totals for Matrix or Table
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!
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.
6 Replies
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
This is odd, can you please share a pbix with some sample data.
Regards
Tom
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
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.
