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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Raulx_7
Helper I
Helper I

Waterfall chart with data from a measure

Hi, I would like to know if there is a way to create a temporary table form a measure function. 

 

I want to create a waterfall chart, I have 3 measures, one calculate the sales, the other the inventory and the third is calculated inventory - sales. 

My problem is that, when I create a waterfall chart I can only add one value.

That's why I decided to know if there is a way to create a temporary table (just for that chart), using those measures.

 

1 ACCEPTED SOLUTION

@Raulx_7 Have you tried creating that in a measure like:

Measure =
  VAR __Table = SUMMARIZE('Table',[Item_name],"Sum",SUM([X]))
RETURN
  <some aggregation over table like SUMX, MINX, AVERAGEX, etc.>

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
Raulx_7
Helper I
Helper I

My table is like : 

 

dateobjectsalesoriginal_itemsammount
     
     
     

 

As a example, 

but 3 measures that calculate using that table, with a date filter.

 

I want to create a waterfall (one of the measures is (item - item + item) using this as result )), with those calculated measures.

 

I wanted to know if there is a way to create a temp table that contains:

 

Item_nameFormula that calculate the value (using the above table)
1 calculate(sum(table[x])) 
2 calculate(sum(table[x]))
3 calculate(sum(table[x]))

 

if I create this using normal dax column, the results for those formulas are not correct. That's why I would like to know if there is a possibility to create a temporal table after I calculate those values. 

@Raulx_7 Have you tried creating that in a measure like:

Measure =
  VAR __Table = SUMMARIZE('Table',[Item_name],"Sum",SUM([X]))
RETURN
  <some aggregation over table like SUMX, MINX, AVERAGEX, etc.>

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
amitchandak
Super User
Super User

@Raulx_7 , the only way to have a temporary table is inside a measure and that will only give you one measure.  Means in case you more than one measure you have to repeat.

You can use Summarize.

 

example :countx(filter(Summarize('Table','Table'[Num_Order], "_1", count('Table'[SKU])), [_1]=1),[Num_Order])

 

You can also have this table in Var

AllisonKennedy
Super User
Super User

I'm not quite sure what you mean, but you can create tables of measures using DAX and then could use that in the visual. See if this post helps: https://radacad.com/aggregated-table-in-power-bi-summarize-function-in-dax/?ref=818

If you can provide a bit more info of raw data format and desired output we can be more helpful.

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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