Forum Discussion
Measure Filter Help
I have the following measure: Measure 2 = IF(MAX(Collections1[Subcategory])="Sales Orders",'Sales Orders'[Sales Orders Value], IF(MAX(Collections1[Subcategory])="Purchase Orders",'Purchase Orders'...
johankent30 can you share how you tables are related?
parry2k right now there is now relationship. I’m not opposed to creating one. If I did it would be a many to one relationship from the collections1 table to the date table
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/38490