Forum Discussion

Ashish9201's avatar
Ashish9201
Helper I
2 years ago

Need help in DAX formula

Hi,    I have created a average function which is as below "Average = (DISTINCTCOUNT(merged_allocation_daily[Project Sys ID])/(DISTINCTCOUNT(merged_allocation_daily[Crew Sys ID])))" However the c...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

Ashish9201 ,  Try a measure like

Sumx(Values(merged_allocation_daily[Crew Company]), calculate(DISTINCTCOUNT(merged_allocation_daily[Crew Sys ID]) ))