The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone,
I need to create a measure that has a virtual table that combines 2 columns from two different tables. Right now I only have the dax to combine two columns from the same table in the summarize function:
Solved! Go to Solution.
Why not try
SUMMARIZE (
DIM_GEO_NO_RLS,
DIM_TERRITORIO_NO_RLS[DES_TERRNIVEL2],
DIM_GEO_NO_RLS[DES_GEONIVEL2]
)
Hi @f_r_1998 ,
You can SUMMARIZE a table also based on columns of other table, if the the other table is on the "1" side of a 1-Many relationship.
Just 1 tip: If you provide code in your post, please format the code and insert it via the "Insert/Edit code sample" box. This will allow users to read and understand your code much more easily.
Br
Hi Manuel, thanks for your reply. The table DIM_GEO_NO_RLS is however on the "many" side of the 1-many relationship since it has all the the cities that belong to the individual states that are in DIM_TERRITORIO_NO_RLS. I tried to do ti like this but it doesnt work:
Why not try
SUMMARIZE (
DIM_GEO_NO_RLS,
DIM_TERRITORIO_NO_RLS[DES_TERRNIVEL2],
DIM_GEO_NO_RLS[DES_GEONIVEL2]
)
User | Count |
---|---|
74 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |