Forum Discussion
Solved
DAX help needed
Here is the link to a sample pbix file https://drive.google.com/file/d/1J4C3V4A98IwZpQbubTlF6tPWlwXQG2Ir/view?usp=sharing or to Excel file https://docs.google.com/spreadsheets/d/18SXUttN51bZLLPfKXnV...
Hello @Gabry , the total is ok but not the dispatch by Activity even with a slight change to the measure you kindly provided
Count of Activities Measure =
VAR _mon = SELECTEDVALUE(Classeur[Monday])
RETURN
CALCULATE(
COUNT(Classeur[Activity]),
ALLEXCEPT(Classeur, Classeur[Activity]),
Classeur[Start_Date] <= _mon,
Classeur[End_Date] >= _mon
)
Gabry
Super User
Super UserI see. In that case I think you need to create another table, a Mondays table, use it in the column. I attach a sample pbix
I think like this can work but I don't know if it's a feasible solution for you. Let me know, maybe I can think of other solutions