Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
mcornejo_1
Helper I
Helper I

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

 

Chart.png

 

1 ACCEPTED SOLUTION
v-gizhi-msft
Community Support
Community Support

Hi,

 

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

91.jpg

92.jpg

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

View solution in original post

2 REPLIES 2
mcornejo_1
Helper I
Helper I

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
Community Support
Community Support

Hi,

 

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

91.jpg

92.jpg

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.