Totals should not display for few Rows in Matrix Visual

[likhithar]

Hello Team,

I have a Matrix visual with Month Name in column and another Dimension in row and showing values against those.
If I don't select any month name the totals for Customers should be blank and if i select any single month even then the Total should be blank.
If I don't select any month name the totals for Customers is blank and even if i do multi select also the totals are blank by using HASONEVALUE DAX.

But If I select one month the total is showing up

The DAX is

Measure =

SWITCH(TRUE(),

SELECTEDVALUE('Dimension'[Dim])="Sales",[TotalSales],

SELECTEDVALUE('Dimension'[Dim])="Customers",IF(HASONEVALUE(DateTable[Month of Year]),DISTINCTCOUNT(Sales[CustomerKey])),

SELECTEDVALUE('Dimension'[Dim])="Orders",DISTINCTCOUNT(Sales[SalesOrderNumber]))
Can anyone help me out on this.
TIA

[Anonymous]

Hi @likhithar ,

Can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

BTW, SELECTEDVALUE function not able to handle aggregate multiple row contents. For this sncieaor, you can try to add a variable with summarize function to handle on the detail level and use iterator function to apply the second level aggregations

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng