Need help with totals.

[darrennhg]

Hi Guys,

In the above I have a table here that is running in conjunction with the Image By Cloudscape visual where it is showing depending on the number in the table a tick or a cross, please see the measure I used below with the image URL's:

I'd like a measure that uses or counts the total at the bottom of the table instead to change my visual. I have drafted an example below:

Backup Server Name	Thursday  (30/12/2021)	Friday  (31/12/2021)	Saturday  (01/01/2022)	Sunday  (02/01/2022)	Monday  (03/01/2022)	Tuesday  (04/01/2022)	Wednesday  (05/01/2022)
Server 123	0	0	0	0	0	0	-
Server 200	0	0	0	0	0	0	-
Server 69	0	1	1	0	0	0	-
Server 66	3	1	0	0	0	0	-
Total	3	2	1	0	0	0	-

[v-janeyg-msft]

Hi, @darrennhg 

Have you watched the video, can you modify it?

If in the matrix, the value of total is not what you want, you can modify measure to customize a result for total.

But your description doesn't seem to be accurate, your screenshot is matrix but you are talking about table, and the measure you give returns png image instead of 0 and 1, so how do we know what your data looks like?

Can you share some sample data(not a matrix picture) and your desired result(in visual)? So we can help you soon.

Best Regards,
Community Support Team _ Janey

[mahoneypat · Accepted solution]

Please see this video on how to get the expected total.

(2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube

Pat