Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

edit interactions between two different queries

Hi. I have two queries that needs to link with each other as one is the massive file with all the orders (sales and po) and the other one is the disputes we have - they are totaly different so I had...
Need Help
affan's avatar
affan
Solution Sage
7 years ago

Hi Anonymous,

 

You can create certain measures to be used on your reports which handle the need to apply or ignore the filters from other queries. 

 

For this i would recommend to understand the following two functions in DAX

 

ALLEXCEPT Function (DAX)

ALL Function (DAX)

 

Further if you can share some sample of your data and also the result that you want to acheive, it will be easier to help

 

 

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

 

Regards,

Affan

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you Affan, but still this does not help me as I dont need to remove my query filters. 

My scenario here is two main tables - one has All Orders and other has All Disputes. They are not able to be linked. But I do need them to show on my report as the All Orders table is my data to calculate the % of Disputes erros. Thats why I need both to be showing on the report and when I do select a date I need them to reflect together on the report.