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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.