Forum Discussion

160475's avatar
160475
Icon for Helper I rankHelper 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   
Need Help
  • visheshjain's avatar
    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

160475's avatar
160475
Icon for Helper I rankHelper 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's avatar
visheshjain
Icon for Impactful Individual rankImpactful 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