Forum Discussion
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
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
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
doens't work