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
Can anyone help me with the following;
Measure =
IF (
AND (
CONTAINS (
'table1',
'table1'[FID_Custom], "TRUE"
),
CALCULATE (
CONTAINS (
'table1',
'table1'[Status], "Validated"
)
)
),
1,
0
)
=> I want to get all rows with 'table1'[FID_Custom]"TRUE" and 'table1'[Status] "Valiated" => currently I get only the "TRUE" once.
It is a IF condition with multiple selections.
Many thanks
Solved! Go to Solution.
Hi @tomkribi
Try
Measure =
CALCULATE (
COUNT ( 'table1'[FID_Custom] ),
'table1'[FID_Custom] = TRUE (),
'table1'[Status] = "Validated"
)
if FID_Custom is of Boolean type. Or:
Measure =
CALCULATE (
COUNT ( 'table1'[FID_Custom] ),
'table1'[FID_Custom] = "TRUE",
'table1'[Status] = "Validated"
)
if FID_Custom is of text type.
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Great, many thanks, this is the solution for me
Measure = CALCULATE ( COUNT ( 'table1'[FID_Custom] ), 'table1'[FID_Custom] = "TRUE", 'table1'[Status] = "Validated" )
Hi @tomkribi
Try
Measure =
CALCULATE (
COUNT ( 'table1'[FID_Custom] ),
'table1'[FID_Custom] = TRUE (),
'table1'[Status] = "Validated"
)
if FID_Custom is of Boolean type. Or:
Measure =
CALCULATE (
COUNT ( 'table1'[FID_Custom] ),
'table1'[FID_Custom] = "TRUE",
'table1'[Status] = "Validated"
)
if FID_Custom is of text type.
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Great, many thanks, this is the solution for me
Measure = CALCULATE ( COUNT ( 'table1'[FID_Custom] ), 'table1'[FID_Custom] = "TRUE", 'table1'[Status] = "Validated" )
Hi @tomkribi ,
There is a simpler way of writing your IF statement: (Create a caluclated column)
calcColumn = IF('table1'[FID_Custom] = "TRUE" && 'table1'[Status] = "Valiated", 1, 0)
If this doesn't help post some sample data and desired output.
Thanks,
Pragati
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 |
---|---|
44 | |
21 | |
20 | |
16 | |
15 |
User | Count |
---|---|
46 | |
28 | |
25 | |
18 | |
17 |