edit interactions between two different queries

[Anonymous]

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 to link them trhoug other two queries - date and divisions. My data is pulling perfectly accurate and I do have nice reports showing both datas. But my reports can not have "edit interacions" because If I select something in a chart shwoing the disputes, the card with all the transaction numbers (sales and po) will not update.

Is it possible to have a edit interactions between two different queries that are indirectly linked ?

thanks in advance.

[v-shex-msft]

Hi @Anonymous,

I think you need to manually calculate with filter condition through tables, can you please share some sample data to help use clarify your scenario and test?

Regards,

Xiaoxin Sheng

[Anonymous]

Hi v-shex-msft , thanks but my filters Im refering to in on the report where Im selecting dates and customers for example via slicer options. 

[affan]

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]

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.