Keep only slicer as a filter for a tooltip and ignore the points on the line chart

[Clout]

Hello guys,

I visualised a line chart with a Date / Value Table and created a measure, how many values within a certain limit are existing and divided them with the total number of values to get the percentage of the maintained limit.

Now I want to create a tooltip with two cards. The first card shows the value I point on, and the second card shows the created measure as percentage. So the first card should show the value which is point on, but the second card should show the percentage value within the time intervall from the slicer and not from the specific point. The second card should behave like it is on the same page

I made two pictures to explain my problem better.

This is how it now is. As you can see I get a 0% Maintained Limit because the point is over the certain limit. But you can see to, that the other card shows the total percentage of the time intervall.

And this is how I want it. So "GesP" should be filtered by the point, but "Maintained Limit" should ignore the point and show the value like the card below.

Thank you in advance!

[Anonymous]

@Clout 

Try ALL like the following dax:

RM_P = VAR numerator = CALCULATE(COUNTROWS(Frachten),

FILTER(All(Frachten), Frachten[AK_C_P] <> Blank() && Frachten[AK_C_P] <= Max('Global'[GW_AblaufPges])))

VAR denominator = Calcuate(COUNT(Frachten[AK_C_P]),All(Frachten))

RETURN DIVIDE(numerator, denominator) + 0

Paul Zheng _ Community Support Team

[Anonymous]

@Clout 

I guess you can edit the maintenance limit measure to ignore filters from point. you may share the formula of maintenance limit measure.

Paul Zheng _ Community Support Team

[Clout]

Hello @Anonymous 

this is my measure:

RM_P = VAR numerator = CALCULATE(COUNTROWS(Frachten),

FILTER(Frachten, Frachten[AK_C_P] <> Blank() && Frachten[AK_C_P] <= Max('Global'[GW_AblaufPges])))

VAR denominator = COUNT(Frachten[AK_C_P])

RETURN DIVIDE(numerator, denominator) + 0

I tried it with ALL or ALLEXPECT, but nothing did work. Maybe I choosed the wrong table

[amitchandak]

@Clout , In case you select a date and want to display dates more than that, you need to use one independent date table

Refer to my video : https://www.youtube.com/watch?v=44fGGmg9fHI

Also, refer: https://www.youtube.com/watch?v=lOEW-YUrAbE

[Clout]

Hello @amitchandak , thank you for your suggestion. 

But I have already a independent date table.