Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 @felipereyes_ ,
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]
)
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |