Forum Discussion

Zak-Echelon's avatar
Zak-Echelon
Frequent Visitor
7 years ago
Solved

How to disable sub totals for string values on matrix visual?

I have a report I am developing using the matrix visual that has two columns from my dataset in the rows column, RowColumnOne and RowColumnTwo, which are both strings. I also have several columns fro...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Zak-Echelon is ISINSCOPE dax function to achieve this. There is a great post on it.

Zak-Echelon's avatar
Zak-Echelon
Frequent Visitor
7 years ago

jdbuchanan71 

parry2k 

 

Currently, my ISINSCOPE function returns false for every row of the dataset.  Is there a specific way I need to configure my data to get it to work properly?

 

Here is a screenshot of the matrix configuration panel from power bi desktop.  Cannot share a picture of the matrix itself as it has confidential data. The is inscope measure is just IsInScopeMeasure = ISINSCOPE(Table[Column])

 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Zak-Echelon did you had chance to go thru the post I sent to you earlier, you will wrap your existing measure in If or switch condition so that it doesn't show the text on total.

  • Zak-Echelon's avatar
    Zak-Echelon
    Frequent Visitor
    7 years ago

    parry2k 

     

    I figured out the issue.  I was using ISINSCOPE on the wrong columns.  I was originally calling ISINSCOPE on the string value column, when I should have been calling it on the sub group column.  Once I made that switch, everything works as expected.

     

    Thanks for the help!