Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Drill through with Measure

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 

General Comment
Need Help
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

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

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    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.