Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all! I have a series of measures that return a single value. I am currently displaying them on individual cards and arranging them in a table (some measures are the difference of other measures) i.e. the delta. I'd like to construct a table that can be populated element-wise with these individual measures. Could I create a new table with DAX perhaps? Thank you for any guidance.
Please see an example below where each element in the table is assumed to be a measure.
@Anonymous ,
Try a new table like
Union (
Summarize(Table,"Name","estimated" ,"Avergae Daily profit",[estimated Avergae Daily profit],"Average Sales",[estimated Average Sales]),
Summarize(Table,"Name","Actual" ,"Avergae Daily profit",[Actual Avergae Daily profit],"Average Sales",[Actual Average Sales]),
Summarize(Table,"Name","Diff" ,"Avergae Daily profit",[Diff Avergae Daily profit],"Average Sales",[Diff Average Sales]),
)
Hi @amitchandak thank you for your answer. It definitely works! However, when I change the context of the underlying measures e.g. with a date slicer, this is not reflected in the newly created table. Is there any way around this? Additionally the measures will come from different tables but I assume this not to be an issue if the relationship model is well configured.
EDIT: Having done some research I believe it is not possible to do this? This is because "New Tables" created by DAX formulas are evaluated once on startup. Thus any filters added on (i.e. by slicers) will not have an effect on the table. Is this correct?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |