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
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:
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 |
Solved! Go to 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.
If i misunderstand your requirement, please for free to let me know.
Best Regards,
Giotto Zhi
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.
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.
If i misunderstand your requirement, please for free to let me know.
Best Regards,
Giotto Zhi
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
94 | |
91 | |
82 | |
69 |
User | Count |
---|---|
161 | |
127 | |
124 | |
108 | |
97 |