Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Table from measures does not consider Date slicer

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 

table union measure slicer

5 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    4 years ago

    Anonymous 

    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's avatar
    smpa01
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Anonymous  maybe try this

    Table = summarizecolumns(t1[date],"m1",[measure1],"m2"[measure2]..."mN",[measureN])
    • smpa01's avatar
      smpa01
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Anonymous  did you try the above?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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

     

    ?