Forum Discussion

Icon for Helper I rank

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

Icon for Impactful Individual rank

Impactful Individual

3 years ago

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

Icon for Helper I rank

Helper 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
Impactful 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?
- 160475
  Helper I
  3 years ago
  no its not the same my filter is another column
  - visheshjain
    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