Create a measure in card that sum three different filtered values

[Step927]

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

[v-tangjie-msft · Accepted solution]

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. 

[Step927]

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

[BrunoTalini]

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!