Forum Discussion

Helper I

3 years ago

Solved

ignoring total value

dears i have the table below i would like to apply filter but ignore total value so i can show right percentage can anyone help

visheshjain
3 years ago
In that case use ISINSCOPE()

Something on the lines of:

Measure =
IF(

ISINSCOPE('Column name used on the rows of the Matrix'),
[total tickets],

CALCULATE([total tickets],ALL(Query1[WT_MNS]))
)

This should keep the filters on only the total while filtering the values in the matix.

Hope this helps.

Thank you,

Vishesh Jain

Helper I

3 years ago

no its not the same my filter is another column

Impactful Individual

3 years ago

In that case you will need to use that column.

It would be really helpful if you could please upload a sample file with the desired result, as it will help us understand the problem better.

Thank you,

Vishesh Jain

160475
Helper I
3 years ago
i got you and changed the measure to this
Measure = CALCULATE([total tickets],ALL(Query1[WT_MNS]))
but it locked the whole column i just want to lock the total
- visheshjain
  Impactful Individual
  3 years ago
  In that case use ISINSCOPE()
  
  Something on the lines of:
  
  Measure =
  IF(
  
  ISINSCOPE('Column name used on the rows of the Matrix'),
  [total tickets],
  
  CALCULATE([total tickets],ALL(Query1[WT_MNS]))
  )
  
  This should keep the filters on only the total while filtering the values in the matix.
  
  Hope this helps.
  
  Thank you,
  
  Vishesh Jain