Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Unable to drillthrough on measure or numeric/boolean column

I have what I thought is a straight forward table and bar chart. The original table has a column "IsOutOfStock" that shows either True or False. The bar chart is supposed to reflect the number of "IsOutOfStock" rows that are "True" grouped by the Date. When I click DrillIthrough I want to be able to filter the underlying table by Date and the correct "IsOutOfStock" state, in this case True. However, when I do this while it does filter the Date correctly I still get the rows that reflect "False". Initially I created a measure to count them:

 

StockOutOnly = COUNTX( FILTER( StockOut, StockOut[IsOutOfStock] = "True" ), StockOut[IsOutOfStock] )
 
This did not filter out the rows so I assumed that is because StockOutOnly is not a column in the original table. So I created a column "IsOutOfStockNum" in the table that shows True = 1 and False = 0, made it data type Whole Number then used that field in the bar chart since it is now in the table as well. This did not work either. I am not sure what I am missing to be able to filter through properly.
 
DateInternalShipmentNumIsOutOfStockIsOutOfStockNum
1/29/20201075009FALSE0
1/29/20201075003FALSE0
1/28/20201074235FALSE0
1/28/20201074936FALSE0
1/29/20201074235TRUE1
1/29/20201074235TRUE1
1/29/20201074235TRUE1
1/28/20201074235TRUE1
1/28/20201075012TRUE1

 

 

Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    After my test, i use your measure and it shows the correct result:

    The above shows the correct number of 'IsOutOfStock' rows that are 'True' grouped by the Date.

    Here is the test pbix file.

    pbix 

    If i misunderstand your requirement, please for free to let me know.

     

    Best Regards,

    Giotto Zhi

2 Replies

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi,

     

    After my test, i use your measure and it shows the correct result:

    The above shows the correct number of 'IsOutOfStock' rows that are 'True' grouped by the Date.

    Here is the test pbix file.

    pbix 

    If i misunderstand your requirement, please for free to let me know.

     

    Best Regards,

    Giotto Zhi

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you Giotto. Downloading your file helped me realize what I was doing incorrectly. I had created a separate table in the Fields pane to hold all of my measures to keep them organized without thinking about the fact that I needed to keep that particular measure within the same table to make this work. I moved it to the correct table and it now works. Sometimes its the simple things. Thank you again.