Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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

@Anonymous 

 

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-with/td-p/360533

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
Anonymous
Not applicable

@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

 

?

@Anonymous 

 

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-with/td-p/360533

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

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

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

@Anonymous  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!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

@Anonymous  did you try the above?

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors