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,
Could you provide some inputs in writing a dax function for below scenario.
Case
when (table1[column1] = 1 and table2[column1] = 1) then 1
when (table1[column1] = 1 and table2[column1] = 0) then 0
when (table1[column1] = 0 and table2[column1] = 1) then 0
when (table1[column1] = 0 and table2[column1] = 0) then 1
end
there is join between TABLE1 and TABLE2 defined in datamodel.
Thanks
Solved! Go to Solution.
Hi @revansh,
If you share some detail contents, it will be help to clarify your scenario.
If you already cross join or use related function to merge these columns to one table, you can try to use below formula to create a calculate column to return the result.
Result=if([T1 Column1]-[T2 Column1]=0,1,0)
Regards,
Xiaoxin Sheng
Hi @revansh,
If you share some detail contents, it will be help to clarify your scenario.
If you already cross join or use related function to merge these columns to one table, you can try to use below formula to create a calculate column to return the result.
Result=if([T1 Column1]-[T2 Column1]=0,1,0)
Regards,
Xiaoxin Sheng
I would simplify the case statement for DAX purposes. Your case statement returns 1 if either both columns are 1 or both are 0; otherwise, it returns 0.
Two questions:
Three possibilities:
YourColumnName = INT ( table1[column1] = RELATED ( table2[column1] ) )
YourColumnName = INT ( table2[column1] = RELATED ( table1[column1] ) )
YourMeasureName = INT ( SELECTEDVALUE ( table1[column1] ) = SELECTEDVALUE ( table2[column1] ) )
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |