Table from measures does not consider Date slicer

[stefanka]

Hi all,

I need to create a list of calculated sums. My list of data contains a date, an ID, an amount and a Group ID.
Second table got columns "Group ID", "Sum ID", "Name of Sum".

Via relationship from list of data to second table using Group ID I got my first "summarization". 

Next Step is to build several sums from SumID all different calculated. 
So I created a measure for each different calculated sum: 1234, 1235 and so on

Creating a visual from one of these measures is working pretty fine with slicers, especially with Date slicer.

Now I want to list all Measures in a table like this:

Tabelle = UNION (
ROW("This is measure 1",MeasureList[1234]),
ROW("This is measure 2",MeasureList[1235])

)

Unfortunately, this table is not related to Dates - slicers on dates have no impact on this table.

A hint how to connect this table to date slicer would be great.

Thanks 

Stefan 

[stefanka]

@smpa01 yes, but it did not make any difference. I think it is probably as @Fowmy mentioned: does not work this wsas, using measures in a table like this. 

Is there no way in dax to do something like this in SQL

declare @sum1 as decimal(10.2) set @sum1 = select sum(table.column2) from table where table.column1  = 1

declare @sum2 as decimal(10.2) set @sum2 = select sum(table.column2) from table where table.column1=2

select "1234", @sum1 as "Amount1" from table

union all

select "4567", @sum2 as "Amount2" from table

union all

select "4567", sum(@sum1 - @sum2) as "Amount3" from table

?

[v-chuncz-msft · Accepted solution]

@stefanka 

In short, the answer is yes. 

Values in a calculated table are fixed. You'll need to create a composite measure.

https://community.powerbi.com/t5/Desktop/Possible-Analytics-function-dynamic-Total-column-in-chart-w...

[Fowmy]

@stefanka 

As I read and understand your question, you cannot incorporate selections and filters from your reports into the tables that you are creating in the data model level. 

[smpa01]

@stefanka  maybe try this

Table = summarizecolumns(t1[date],"m1",[measure1],"m2"[measure2]..."mN",[measureN])

[smpa01]

@stefanka  did you try the above?