Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
Proud to be a Super User!
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
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
Proud to be a Super User!
i have done this dax :
Hi @160475,
The column that you are using in the measure, is that the same column that you are using on the slicer/filter?
Proud to be a Super User!
no its not the same my filter is another column
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
Proud to be a Super User!
i got you and changed the measure to this
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
Proud to be a Super User!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |