Forum Discussion

Jake_Neyu's avatar
Jake_Neyu
Frequent Visitor
4 years ago

Unexpected result when using ALL within CALCULATE

I have 2 measures: Measure 1: agent total all = CALCULATE(DISTINCTCOUNT(tms[agent]),all(tms[agent]))   Measure 2: agent total alls = CALCULATE(DISTINCTCOUNT(tms[agent]),ALLSELECTED(tms[agent]))...
POWER BI Dax rules
v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Jake_Neyu ,

According to your description, modify the formula like this:

agent total all =
CALCULATE ( DISTINCTCOUNT ( tms[agent] ), ALL ( tms ) )

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.