Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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.>
My table is like :
date | object | sales | original_items | ammount |
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_name | Formula 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.>
@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
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
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |