D7: Count high-value orders |

[@udaymehta8917]

great explaination from Curbal. Thank you.

[@manthanmistry1205]

Hey Ruth, this is great initiative to learn dax and write it from scratch for scenarios like this. Loving this journey so far ❤

[@CurbalEN]

Thanks!! 😃😃

[@Fajksa]

this exercise is great to practise understanding context, I love it

[@CurbalEN]

Thanks! ❤️

[@Nalaka-Wanniarachchi]

Ruth,I really appreciate how you deconstruct the problem and present the approach step by step.Sometimes i feel dax is becoming boring in this way😁

[@MorrisTube]

Fair question... From where the Year comes from? I first suppose was Order Date, but... If you add any single column that has date and compare with the year column from calendar, several order has years that don't make sense. I'm pretty sure should be a relationship that I'm not aware, but I review the model view, I saw an inactive relationship for shipment which don't look like creating any problem but still can't figure our from where that year is come from. Any comment / idea will be appreciated.

[@edscreations7552]

I calculated average Sales value for entire dataset rather than for 1997 only, that's where I got it wrong

[@manthanmistry1205]

whenever in doubt remember "FFTA" (First Filter Then Aggregate). Hope this helps

[@geineralbertomejiagarzon4034]

My result is different because I used the expression UnitPrice * Quantity, I did not use total Sales after Discount measure, but I guess I'm going to need to use it for the following days.

[@CurbalEN]

Yes please! I use that one all the time moving forward!