Unable to drillthrough on measure or numeric/boolean column

[mcornejo_1]

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.

Date	InternalShipmentNum	IsOutOfStock	IsOutOfStockNum
1/29/2020	1075009	FALSE	0
1/29/2020	1075003	FALSE	0
1/28/2020	1074235	FALSE	0
1/28/2020	1074936	FALSE	0
1/29/2020	1074235	TRUE	1
1/29/2020	1074235	TRUE	1
1/29/2020	1074235	TRUE	1
1/28/2020	1074235	TRUE	1
1/28/2020	1075012	TRUE	1

[mcornejo_1]

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.

[v-gizhi-msft · Accepted solution]

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