How to show totals for measures in a matrix/table view in power bi

[Brighton10]

Hi all. I have a table visual which i used to display some measures. However I would also like to show the total sum of the columns but power BI totals pane only shows for one measure which is also wrong, as it does not filter accordingly. Under Confirmed the total should be 239, QR scan 188 etc. The totals must dynamically change when i filter with the version or fullname. Please assist, Thank you 

[aj1973]

Hi @Brighton10 

In the Visual Table/Format is Totals on?

can you screen shot your measures?

[Brighton10]

@aj1973, Yes the total is on thats why the total 1542 is there. 

[aj1973]

@Brighton10 

For Confirmed and QRScan, you are counting the number of names in a non empty cells, correct?

Use COUNTA or COUNTX see how it works out

[Brighton10]

@aj1973 , Yes I am counting in a non empty cell. I did used counta and countx but its not showing the totals. Let me try to upload the pbix file if that will help.

[aj1973 · Accepted solution]

@Brighton10 

No need for SELECTEDVALUE, make it simple and use these formulas

Confirmed_Me = CALCULATE(COUNT('db_fieldtrials tbl_user_decoder_software'[user_name]),'db_fieldtrials tbl_user_decoder_software'[deleted]=0)

QRScan_ME = COUNT(qrcode_scan[full name])

[aj1973]

You can send me the link in Private if that could make you more confi...