Forum Discussion
160475
Helper I
Helper Iignoring 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
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
Impactful Individual
Impactful IndividualHi 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
160475i have done this dax :
Measure = CALCULATE([total tickets],ALL(Query1[TICKETS]))but still the total change once i apply filtir- visheshjain
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
no its not the same my filter is another column