Forum Discussion

rit_ty7's avatar
rit_ty7
Icon for Advocate I rankAdvocate I
1 year ago

Help with the dax formula

Hello everyone, is the below formula correct for calculating productive calls(pc) for lighting? PC Total Call_lighting = var a = CALCULATE(COUNT(SECONDARY_VISIT_DATA_NEW[VISIT_ID]), FILTER(SECONDA...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Abhijeet_40's avatar
Abhijeet_40
Icon for Helper I rankHelper I
1 year ago

Hello!

Just a couple of questions. Why are using filter and using an inline method:
PC Total Call_lighting =
CALCULATE(
COUNT(SECONDARY_VISIT_DATA_NEW[VISIT_ID]),
SECONDARY_VISIT_DATA_NEW[NON_PRODUCTIVE] = "NO",
MATERIAL_ATTRIBUTES_CL[MAIN_GROUP] IN {
"Conventional",
"D-Lite",
"Elect. Accessories",
"LED Battens",
"LED Lamps",
"LED Outdoors"
}
)

If this won't work for you. Why not use both the filter block in a single calculate block?