cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stefanka
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

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

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.

View solution in original post

5 REPLIES 5
stefanka
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

 

?

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

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.
Fowmy
Super User
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


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

smpa01
Super User
Super User

@stefanka  maybe try this

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






New Animated Dashboard: Sales Calendar


@stefanka  did you try the above?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






New Animated Dashboard: Sales Calendar


Helpful resources

Announcements
Carousel_PBI_Wave1

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.

Power BI Summit Carousel 2

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!

Thank you 2022 Review

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