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

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