cancel
Showing results for
Did you mean:
Regular Visitor

## 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

1 ACCEPTED SOLUTION
Community Support

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...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Regular Visitor

@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

?

Community Support

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...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User

@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.

Did I answer your question? Mark my post as a solution! and hit thumbs up
Super User

@stefanka  maybe try this

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

Proud to be a Super User!

New Animated Dashboard: Sales Calendar

Super User

@stefanka  did you try the above?

Proud to be a Super User!

New Animated Dashboard: Sales Calendar

Announcements

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### 2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors