Drillthough not filtering through a measure

[LP2803]

Hi Team,

Below is the matrix visual in from a page (image1) and i have a drillthrough to page "Quality" (ima ge 2).

I have created three measures (Latency?, PakcetLoss? & SysMaxCPU?) to check if any of the meetings meets the criteria mentioned in the filter.

PacketLoss? = if(COUNTROWS(

FILTER(

Filter('Sheet1 (2)','Sheet1 (2)'[Attribute.2]="packetLoss"),

'Sheet1 (2)'[Value]>5)) > 3,1,0)

Latency? = if(COUNTROWS(

FILTER(

Filter('Sheet1 (2)','Sheet1 (2)'[Attribute.2]="latency"),

'Sheet1 (2)'[Value]>400)) > 1,1,0)

SysMaxCPU? = if(COUNTROWS(

FILTER(

Filter('Sheet1 (2)','Sheet1 (2)'[Attribute.2]="systemMaximumCPU"),

'Sheet1 (2)'[Value]>90))>10,1,0)

when i right click on the "Latency?" and go to "Quality" page, I expect to see the line chart for that Particular ID and the participant mentioned under the meetingInstanceID and also "Latency?" 

Currently, it does pass the MeetinginstanceID and the Participant but not the Latency? / PacketLoss? / SysMaxCPU? .

Could you please help me how can i make it possible?  I tried to add it in these measures in the tooltip. but you know it loos gross when user over on the linechart to see the values. any other idea please?

[v-yingjl · Accepted solution]

Hi @LP2803 ，

When you use measures as drillthrough parameters, you will find 'keep all filters' become grey, this is becasue measures are entirely based on the filter context and has passed through all the filters.

In this case, if you want to pass parameters based on calculations and show it in the drillthrough parameter, you may try to convert your measure into calculated columns.

You can also refer: Power BI - Measure Drillthrough 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@LP2803 , Have you added MeetinginstanceID  to keep filters on drill page ?

[LP2803]

@amitchandak  Yes Amit,  as marked below

[Pragati11]

Hi @LP2803 ,

Drillthrough can be done only on columns not on Measures.

If you convert your measures to Columns, then it will work.

Thanks,

Pragati

[bakesada]

This is an incorrect statement.