Forum Discussion

likhithar's avatar
likhithar
Helper III
3 years ago

Totals should not display for few Rows in Matrix Visual

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
 
 

 

 

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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