Forum Discussion
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...
Hi,
I was able to fix the formula and have created below two to resolve the issue.
1) # of Projects = SUMX(VALUES(merged_allocation_daily[Project Sys ID]),CALCULATE(DISTINCTCOUNT(merged_allocation_daily[Crew Sys ID])))
2) Average = DIVIDE([# of Projects],DISTINCTCOUNT(merged_allocation_daily[Crew Sys ID]) )
Below is the snap of the visual i created using the formulaes,
I am working on to update the visual for crew members to be including in the above visual only if they have worked on 5 or more than 5 projects, when i apply the filter on "# of projects" it only works on the subtotal rather than each line item.
Could you please help me with updating my formulas to including crew members working on 5 or more than 5 projects?
Thank you in advance!
Ashish
Hi Team,
Can someone please help me with solution on updating my formulas to including crew members working on 5 or more than 5 projects?
Thank you,
Ashish Gupta