Modeling for a week

[Ben_137ch205]

Hey community,

I do this chart :

It's an average of volume by hour and by days (monday, thuesday, etc.)

In order to acheive this chart, I use the followings measures (7 times!!!!!):

Volume thursday= CALCULATE([avergae volume dayly],TBL_Day[#]=4)

Do you have a bettre soluton than copy paste 6 time this formula... I am not sure to use the right chart do to it, because, when you use the Matrix table, it works amazing (juste one measure) :

thanks for your help

[Ben_137ch205]

Thanks!!!

[Ritaf1983]

Happy to help 🙂

[Ritaf1983 · Accepted solution]

Hi @Ben_137ch205 

You can use the weekday as a legend, instead of 7 measures :

pbix with example is attached

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