Please follow below.
1. In the load script, Add below codes
LEt vColorLight=rgb(176,242,242);
LEt vColorMiddle=rgb(153,204,255);
LEt vColorMixDark=rgb(40,115,204);
2. Create a var chart object.
3. Go to Appearance > Colors > Disable the auto > Choose « By Expression » > Add below expression.
ColorMix2((rank(total Column(1))/(noofrows(TOTAL)/2))-1,$(vColorMixDark), $(vColorLight),$(vColorMiddle))






![[PowerBI][DAX] – CALCULATETABLE() dax powerbi fonction CALCULATETABLE](https://i0.wp.com/mybicoach.bwabwanet.fr/wp-content/uploads/2020/03/powerbi-dax-CALCULATETABLE.png?resize=218%2C150)


![[PowerBI][DAX] – Comment compter le nombre de ligne d’une table ?](https://i2.wp.com/mybicoach.bwabwanet.fr/wp-content/uploads/2020/01/powerbi-dax-countrows-logo-1.png?resize=100%2C70)