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 there,
I have searched the forum and tried multiple suggestions but I have not managed to work it out. What I like to do is add a new column, that shows a 1 if the condition is met otherwise 0. I am using the formula below but shows all items as 0. If I filter manually on the columns than multiple records show up. Does anyone has an idea how to do this better? Thanks in advance.
Solved! Go to Solution.
Hi,
I am not sure if I understood your question correctly, but please try the below.
I think, the reason why the result only shows zero is because of the column, 'Cority_Corrective_Actions_M_001 SiC'[Status] = "Action - In Progress" and "Action - Ready for Review"
I am not sure, but I think the [Status] column in one row cannot have two result at the same time.
Lagging - Survey items overdue =
IF (
'Cority_Corrective_Actions_M_001 SiC'[Reference Type] = "Safety Inspection/Survey"
&& OR (
'Cority_Corrective_Actions_M_001 SiC'[Status] = "Action - In Progress",
'Cority_Corrective_Actions_M_001 SiC'[Status] = "Action - Ready for Review"
)
&& 'Cority_Corrective_Actions_M_001 SiC'[Observation Status] = "Overdue",
1,
0
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
As you used "&&"in your Dax for the Status column in 2 different values, the result of the If function should go to Else (0).
If you want to check if the Status is "Action - In Progress" or "Action - Ready for Review", you need to put "||" or OR() in your dax formula
Hi,
I am not sure if I understood your question correctly, but please try the below.
I think, the reason why the result only shows zero is because of the column, 'Cority_Corrective_Actions_M_001 SiC'[Status] = "Action - In Progress" and "Action - Ready for Review"
I am not sure, but I think the [Status] column in one row cannot have two result at the same time.
Lagging - Survey items overdue =
IF (
'Cority_Corrective_Actions_M_001 SiC'[Reference Type] = "Safety Inspection/Survey"
&& OR (
'Cority_Corrective_Actions_M_001 SiC'[Status] = "Action - In Progress",
'Cority_Corrective_Actions_M_001 SiC'[Status] = "Action - Ready for Review"
)
&& 'Cority_Corrective_Actions_M_001 SiC'[Observation Status] = "Overdue",
1,
0
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Amazing, that sorted it! I get your point now about two variables in the same column. Thanks heaps, that took me all morning.
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 |
---|---|
99 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
105 | |
86 | |
72 |