Forum Discussion
Calculating average daily count from counting rows?
leobelyaev , Avg Daily would be like
Averagex(Values(Date[Date]), calculate(Count(Table[Column])) )
If you want to switch with the level you can use isinscope
Avg of Sum : https://youtu.be/cN8AO3_vmlY?t=22980
Isinscope
https://youtu.be/cN8AO3_vmlY?t=31995
IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM
leobelyaev , Avg Daily would be like
Averagex(Values(Date[Date]), calculate(Count(Table[Column])) )
If you want to switch with the level you can use isinscope
Avg of Sum : https://youtu.be/cN8AO3_vmlY?t=22980
Isinscope
https://youtu.be/cN8AO3_vmlY?t=31995
IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM
Hi, thank you so much Amit Chandak,
That helped a lot, I checked out your tutorial and used the code you sent.
However, I get very different results when using the formula you suggested, and when i tried to copy the forumla from your tutorial. I can't quite figure out why and how the results are so different from using seemingly similar logic behind the two formulas.
Do you think you could explain how this could be happening? If you could, you'd be better than ChatGPT, because it failed to explain to me hahah.
The first matrix uses this measure:
By the way, planning to watch the rest of your 11.5 hour beginner course, you are great at explaining concepts, hands on, with examples, step by step! I really liked what I saw so far!