Calculated measure can be used to join another table

[ack2mani]

Hi Friends,

 Can we use a calculated measure in a table to join another table in Power BI?  If yes plz help me out ASAP

Thanks! in Advance

[v-juanli-msft]

Hi @ack2mani

What final result do you want? a table or a column?

If you want to get a table finally, you need to create a new table instead of a measure.

Besides, you can create a virtual table in a measure and use this table to calculate the final result of this measure, like

measure= VAR table1=SUMMARIZE(ALL(sheet1),[Column1])
 Return CALCULATE(SUM([Column1]),ALL(table1))

Functions you need to consider

VAR

Indetify variables

UNION

Creates a union (join) table from a pair of tables

CROSSJOIN

Returns a table that contains the Cartesian product of all rows from all tables in the arguments

SUMMARIZE

Returns a summary table for the requested totals over a set of groups

Best Regards

Maggie

[jthomson]

You could probably use DAX to create a temporary table using the measure, but it'd probably be messy and maybe not an ideal solution if you're wanting to use the new table in several places - I'd try to recreate the measure in Power Query if at all possible

[ack2mani]

Thanks @jthomson Plz let me know if possible

[RMDNA]

@ack2mani,

We won't know if it's possible until you give us a better idea of what you're trying to do. Can you share some data, your specific goal, and the expected result?