OPERATIONS WITH FILTERED VALUES

Question

Good day to all the members of the community, I turn to your kind support for a Power BI requirement that I have not been able to solve; I have a basic dashboard from which you get technical reports, but for the presentation of some visuals I need to perform operations between two pieces of data obtained by using filters.

For example

In the yellow visual you should get 20 which is the subtraction of 29-9, it should be noted that the values 29 and 9 are obtained separately since they belong to a single table but are different columns. I have tried to solve the problem with several alternatives but I have not been able to solve it, I tried creating quick measurements with filtered values, using a new measure with the "FILTER" option and with max and min values but I cannot get such a calculation, which in excel would be as simple as subtracting 2 cells. I attach a .pbix file and excel data from where the dashboard comes from for your collaboration.

syndicate_admin · Answer

Sorry I have not been able to attach the files in question, I am not allowed to, I send an image of the excel data and I am also attentive to see if someone tells me how I can attach the respective files. Thank you

anonymous · Answer

Hi&nbsp;Alejo_Perez&nbsp; Please first refer to&nbsp;How to provide sample data in the Power BI Forum

syndicate_admin · Answer

I attach a path with the respective files for your prompt collaboration. Thank you https://we.tl/t-X6nFulyGyB

syndicate_admin · Answer

Good day, I still don't receive support with this issue, do you have some response time or can you tell me how the management of the community, for other posts that have been made you have more agile responses, Thank you and sorry for the inconvenience

anonymous · Answer

Hi&nbsp;Alejo_Perez&nbsp;
&nbsp;
Sorry for the late response. I apologize that I haven’t found a good solution based on the current model and tables.&nbsp;
&nbsp;
As a workaround, I added two tables which are disconnected from the original tables and created some new measures to achieve the result.&nbsp;

As this will change other visuals on the same page, you may need to adjust those visuals accordingly. I add a duplicated page in the .pbix file. Hope this would be helpful.&nbsp;
&nbsp;
Best Regards,JingIf this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Forum Discussion

OPERATIONS WITH FILTERED VALUES

7 Replies

Related content

SQL Operator with multiple destinations

FILTER - AND operator

not equal operator not filtering

Use Wildcard Operator

Filter values based on arithmetic operations