The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi Experts,
I have wrote the DAX formula for my scenario as below :
if "Do we have required resourcing for the project?"is no, then Amber
if "Are there attritions/Backfill delayed?" is Yes, then Amber
if "Are we having any skill issues in the team?" if Yes, then Red
if any one of them is red above, then Red, if none of them red and any one of them amber then Amber
DAX :
It is working fine when all the columns are updated with Yes or No , but i need to update the DAX like "if all the columns are blank then the output (Resourcing logic column) should give BLANK" .
FYI : With the current formula it is showing "Amber" when all columns are blank.
I have tried few changes but not worked as expected.
Can anyone please help to check and solve me with the updated DAX ?
Thanks
DK
Try this calculated column:
Resourcing logic =
VAR _if1 =
IF (
'Test Delivery Updates'[Do we have required resourcing for the project?] = "No",
"Amber",
BLANK ()
)
VAR _if2 =
IF (
'Test Delivery Updates'[Are there attritions/Backfill delayed?] = "Yes",
"Amber",
BLANK ()
)
VAR _if3 =
IF (
'Test Delivery Updates'[Are we having any skill issues in the team?] = "Yes",
"Red",
BLANK ()
)
VAR _text = _if1 & "-" & _if2 & "-" & _if3
RETURN
SWITCH (
TRUE,
ISBLANK ( _if1 ) && ISBLANK ( _if2 ) && ISBLANK ( _if3 ), BLANK (),
IF ( CONTAINSSTRING ( _text, "Red" ) = TRUE, "Red", "Amber" )
)
Proud to be a Super User!
@DataInsights Thanks for a solution 🙂
I have tried to modify the formula as below and after that it is giving result as "Red" for all the accounts instead of a specific account , i don't know why 😞
for example :
Account | Q1 | Q2 | Q3 | Resourcing |
XYZ | No | Amber | ||
ABC | Yes | Red | ||
AAA | No | Red | ||
BBB | Red | |||
CCC | Red | |||
DDD | Red |
User | Count |
---|---|
16 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
8 | |
8 |