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 relations...
table union measure slicer
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

 

?