Dynamic Calculation based on selected slicers

[Tring01]

Hi Team

I need a small kind of requirement I have using a estimate type column as a slicer its having multiple fields based on the selection of multiple filds we need to do the calculation like below screenshot and result should be shown in a matrix table same as like below example. how can we do this with the help of dax please help me on this. Thank you so much in advance.

[v-cgao-msft · Accepted solution]

Hi @Tring01 ,

You can create two unconnected tables for two slicers.

Model.

Output:

Please check the attachment.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Tring01]

Thank you so much it was working as expected I need to include one more point here please suggest me how to do that base on the comparision of the 2 slicers the results should in conditional formatting applied. below is the scenario

=> If the resulted value is more 5% sales than slicer1 selected sale value then resulted sale value background colour should be red in colour.
=> If the resulted value is less 5% sales than slicer1 selected sale value then resulted sale value background colour should be green in colour.

Else 

Yellow in colour

Could you please help me in this scenarion. I reaaly appreciate your help.

Thank you so much in advance.

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...