Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
IF(HASONEVALUE('Marketing FTD'[Reporting Channel]),
IF(HASONEVALUE('Marketing FTD'[Team Reporting Channel]),
SWITCH( TRUE(),VALUES('Marketing FTD'[Reporting Channel])="Direct",
COUNT('Marketing'[FTD_Count])+(SUMX(ALL('Marketing FTD'[Reporting Channel]),[No of First Deposits])-SUMX(ALL('Marketing FTD'[Reporting Channel]),[Marketing No of FTD1])),
VALUES('Marketing FTD'[Team Reporting Channel])="Direct",
COUNT('Marketing'[FTD_Count])+(SUMX(ALL('Marketing FTD'[Team Reporting Channel]),[No of First Deposits])-SUMX(ALL('Marketing FTD'[Team Reporting Channel]),[Marketing No of FTD1])),
COUNT('Marketing'[FTD_Count])
)
,COUNT('Marketing'[FTD_Count])
)
)
Above dax exp,I need to check both condition in switch but it working till first condition
doubt:In switch if first condition is true then second is not check ?
@ShaikRafi , In switch, if the first condition is true it will not check second , you can use and or or
SWITCH( TRUE(),VALUES('Marketing FTD'[Reporting Channel])="Direct" && VALUES('Marketing FTD'[Team Reporting Channel])="Direct",
COUNT('Marketing'[FTD_Count])+(SUMX(ALL('Marketing FTD'[Reporting Channel]),[No of First Deposits])-SUMX(ALL('Marketing FTD'[Reporting Channel]),[Marketing No of FTD1])),
VALUES('Marketing FTD'[Team Reporting Channel])="Direct",
COUNT('Marketing'[FTD_Count])+(SUMX(ALL('Marketing FTD'[Team Reporting Channel]),[No of First Deposits])-SUMX(ALL('Marketing FTD'[Team Reporting Channel]),[Marketing No of FTD1])),
COUNT('Marketing'[FTD_Count])
)
,COUNT('Marketing'[FTD_Count])
)
)
for me
if VALUES('Marketing FTD'[Reporting Channel])="Direct" output COUNT('Marketing'[FTD_Count])+(SUMX(ALL('Marketing FTD'[Reporting Channel]),[No of First Deposits])-SUMX(ALL('Marketing FTD'[Reporting Channel]),[Marketing No of FTD1]))
if VALUES('Marketing FTD'[Team Reporting Channel])="Direct"
COUNT('Marketing'[FTD_Count])+(SUMX(ALL('Marketing FTD'[Team Reporting Channel]),[No of First Deposits])-SUMX(ALL('Marketing FTD'[Team Reporting Channel]),[Marketing No of FTD1]))
How can check both condition at time
@ShaikRafi , in the same measure you can not return values at the same time. It can one return with && or || in if. Else one will come first
Else add the results of two if
IF(
HASONEVALUE('Marketing FTD'[Reporting Channel]),
IF(
HASONEVALUE('Marketing FTD'[Team Reporting Channel]),
IF(VALUES('Marketing FTD'[Reporting Channel])="Direct",
COUNT('Marketing'[FTD_Count])+(SUMX(ALL('Marketing FTD'[Reporting Channel]),[No of First Deposits])-SUMX(ALL('Marketing FTD'[Reporting Channel]),[Marketing No of FTD1])),
IF( VALUES('Marketing FTD'[Team Reporting Channel])="Direct" ,
COUNT('Marketing'[FTD_Count])+(SUMX(ALL('Marketing FTD'[Team Reporting Channel]),[No of First Deposits])-SUMX(ALL('Marketing FTD'[Team Reporting Channel]),[Marketing No of FTD1])),
COUNT('Marketing'[FTD_Count]))
)
,COUNT('Marketing'[FTD_Count])
)
)
wrote query with if condition still working first part of condition not going to second condition
Can you please help
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 3 | |
| 3 | |
| 3 |