Forum Discussion
Measure Filter Help
johankent30 as best practice it will be easier to have relationship.
- Okay, is it possible to filter the subcategory values by a date selected on the date table then? How would the DAX look in my formula?
johankent30 share sample data from tables you currently have and explain what you want. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490parry2k I've tried to include more info, but let me know if you need anything else. I have the following visual.
You can see that I am analyzing the AP data by a date heiarchy. The table that feeds this visual looks like this.
What I am hoping to do is to create a date slicer that can filter just the subcategory of "Purchase Orders". So referring back to the first pic attached, the purchase orders amount is $1399 for each day, but I want to be able to select dates from a slicer list and choose which days the purchase orders show up in the visual. So if I selected 9/1/2019 then purchase orders would have $1399 on 9/1/2019 and 0 on all of the other days, but the Payables line would not change. The measure that I believe needs to be changed is in the second pic. I would think there would be a way to filter the Date Value column in the table illustrated above for only the dates selected in a disconnected date table, and for this to only apply if the row had "Purchase Orders" as the subcategory, but I can't seem to figure out the solution. Thanks!