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 community,
Following is my sample dataset:
I want to create 2 columns Result1 & Result2.
Result1 = if the client has value 1 then True
Result1 = if the client has value 3 then True
I want result1 & result2 to look like following in the matrix:
Sample file: https://1drv.ms/u/s!Ag919_pO_UKrgS4axMQY6IFFpowi?e=gIEbYl
Thanks in advance.
Solved! Go to Solution.
@Anonymous Perhaps:
Result1 Measure =
VAR __Values = SELECTCOLUMNS('Table',"__Values",[Value])
RETURN
IF( 1 IN __Values,"TRUE","FALSE")
Result2 Measure =
VAR __Values = SELECTCOLUMNS('Table',"__Values",[Value])
RETURN
IF( 3 IN __Values,"TRUE","FALSE")
@Anonymous Perhaps:
Result1 Measure =
VAR __Values = SELECTCOLUMNS('Table',"__Values",[Value])
RETURN
IF( 1 IN __Values,"TRUE","FALSE")
Result2 Measure =
VAR __Values = SELECTCOLUMNS('Table',"__Values",[Value])
RETURN
IF( 3 IN __Values,"TRUE","FALSE")
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 | |
101 | |
86 | |
64 |