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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors