Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello
I am getting error "Argument '3' in if function is required" in following measure
MissingCertificationengineerBrasil =
IF (
AND (Merge1[Items.Level-2]="Certification issued by Engineer",Merge1[Classifications.Country]="BRASIL" ),
1,
IF (
AND (Merge1[Items.Level-2]="Certification issued by Engineer",Merge1[Classifications.Country]="NAFTA"),
0,
if
(
AND (Merge1[Items.Level-2]="Certification issued by Engineer ",Merge1[Classifications.Country]="europe"),
0,
)
)
)
Solved! Go to Solution.
Delete the comma on your last 0.
Pat
Hello ppm1,
As you suggested, I removed the comman, see below code but it is now giving me another error, we just want to return 1 or 0 depending on condition. Am I missing anything?
"single value for column 'Items.Level-2' in table 'Merge1' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."
IF (
AND (Merge1[Items.Level-2]="Certification issued by Engineer",Merge1[Classifications.Country]="BRASIL" ),
1,
IF (
AND (Merge1[Items.Level-2]="Certification issued by Engineer",Merge1[Classifications.Country]="NAFTA"),
0,
if
(
AND (Merge1[Items.Level-2]="Certification issued by Engineer ",Merge1[Classifications.Country]="europe"),
0
)
)
)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
107 | |
105 | |
89 | |
61 |
User | Count |
---|---|
169 | |
138 | |
135 | |
102 | |
86 |