topic Create a measure in card that sum three different filtered values in DAX Commands and Tips

Create a measure in card that sum three different filtered values

Step927 — Fri, 05 Apr 2024 22:36:14 GMT

Dear All,

I need to create a measure to display on a card that adds the value of three tables connected to a filter. Consider that each table is linked to its own filter and the filters are not synchronized with each other.

Many Thanks

Re: Create a measure in card that sum three different filtered values

BrunoTalini — Sat, 06 Apr 2024 18:05:13 GMT

Hi! How are you?

I think something like that could be solved with the HASONEVALUE() and HASONEFILTER() functions. I can't tell you more than that because I don't know the names of the columns and what the data model looks like. Maybe with more information I can help you a little more. By creating a measure with these functions, you may be able to achieve something good.

Best Regards!

Re: Create a measure in card that sum three different filtered values

Step927 — Sat, 06 Apr 2024 22:08:14 GMT

Hi Bruno,

Thanks for your help.

In that case I need a card with a measure that calculate the total = 91.

In my case I use only the table below. The measure Gol Fatti= SUM('Stagione 2023-2024'[Gf]).

So the 3 tables visual use the same column from the same table but using different selection with filters.

The Column "squadra" used in the filter is in the same table 'Stagione 2023-2024.

Best Regards

Re: Create a measure in card that sum three different filtered values

Anonymous — Mon, 08 Apr 2024 06:23:36 GMT

Hi Step927 ,

Thanks BrunoTalini for the quick reply and solution. I have another idea for you to consider:

(1) This is my test data.

(2) We can create three tables and then model the relationships.

Slicer1 = VALUES('Table'[squadra])

Slicer2 = VALUES('Table'[squadra])

Slicer3 = VALUES('Table'[squadra])

(3)We can create a measure and then the result is as follows.

Measure = var _a=CALCULATE(SUM('Table'[Gol Fatti]),FILTER(ALL('Table'),'Table'[squadra]=SELECTEDVALUE('Slicer1'[squadra]))) var _b=CALCULATE(SUM('Table'[Gol Fatti]),FILTER(ALL('Table'),'Table'[squadra]=SELECTEDVALUE('Slicer2'[squadra]))) var _c=CALCULATE(SUM('Table'[Gol Fatti]),FILTER(ALL('Table'),'Table'[squadra]=SELECTEDVALUE('Slicer3'[squadra]))) RETURN _a+_b+_c

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.