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.
Table_1 contains Name, Description and Date
Table_2 contains Name, Description
in Table_2 i add the Date column by using measure column. The Date is based on a slicer value
When i then use DAX to Union both Table_1 and 2 i get an error as the tables are not equal.
in other words, the Date in Table_2, created by a measure, is not seen as a "real" column
How can i solve this please?
Hey @Anonymous
I have a similar issue, did you figure how to make the table to refresh on slicer changes?
KS
Hey @Anonymous , if you want to have this table appear in the fields pane, the simple answer is: no.
You can use this table as a virtual table inside other measures as input for calculation though.
Regards,
Tom
Hey,
this DAX statement creates a table:
Table = UNION( Table1 ,ADDCOLUMNS( SUMMARIZE('Table2' ,Table2[ID] ,Table2[thisorthat] ) ,"amount", [amount] ) )
there is a measure "[amount]" this is added as a column using the function ADDCOLUMNS(...)
But you have to be aware, that tables (outside of a measure) that are based on a DAX statement will only be re-calculated on data refresh and not if a query is issued, e.g. if a slicer is changed.
Regards,
Tom
Hey Tom,
Is there anyway to make the table responsive to slicers?
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 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |