Drill through with Measure

[Anonymous]

Hi All, 

I am new to PBI and learning the trade but I am facing an issue where I have added Measure that shows the total time of a row by decimal point (0.5 = 30 mins, 1.00 = 60 mins) .. 

I have added this into my graph and table grid on another PBI page but when I try to drill through using the Measure it then adds irrelevant data into my grid (Shown in blue) when all I want the table to show is the values that are showing in the Example 1 column (Shown in Red). 

Is there a way I can Drill through with the Meausre I created and it does not show the extra rows in Blue and only shows the Red values?

Thanks 

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can put your Measure into Filters and set the value not equal to 0. Click on the apply filter to get the view you want.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Drillthrough is based on column filters, not on measures.  You can filter out the zero valued items in your target page though.