ignoring total value

[160475]

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 

[mariussve1]

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

[160475]

doens't work 

[visheshjain]

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]

i 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 

[visheshjain]

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]

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 · Accepted solution]

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