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

9 Replies

  • visheshjain's avatar
    visheshjain
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    Hi 160475,

     

    From what I have understood, for the denominator when dividing you can use the ALL() function, so that will ignore the filters.

     

    Hope this helps.

     

    Thank you,

    Vishesh Jain

    • 160475's avatar
      160475
      Icon for Helper I rankHelper I
      3 years ago

      i have done this dax : 

      Measure = CALCULATE([total tickets],ALL(Query1[TICKETS])) 
      but still the total change once i apply filtir 
      • visheshjain's avatar
        visheshjain
        Icon for Impactful Individual rankImpactful Individual
        3 years ago

        Hi 160475,

         

        The column that you are using in the measure, is that the same column that you are using on the slicer/filter?

  • mariussve1's avatar
    mariussve1
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi,

     

    In the measure you write:

     

    IF ( HASONEVALUE ( Table[Column] ), "measure for tickets count", BLANK ()

    )

     

    Table[Column] = The table and column you have in the Table/Matrix visual

     

    Br

    Marius