Avoiding totals/labels for non-additive columns in Matrix

[Anonymous]

I am trying to create this Matrix table:   I do not need labels in totals for the non-additive columns.  I only want to see the Total amount.  I am unable to see any settings under Format grid of PowerBI desktop to achieve this.  

I also want to be able to show row count for each currency. 

Something close to below:

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

Please see the attachment.

You can use the HASONEVALUE function to control the return value of subtotals.

Measure = IF(HASONEVALUE('Table'[Date]),MAX('Table'[ID]),COUNT('Table'[ID]))

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Hariharan_R]

Hi

Try to move the non-additive columns into rows and off the stepped Layout.

Thanks

Hari