Sales by day as a % of total week

[Justas4478]

Hello, is it possible to create measure that calculates Sales by day as a % of total week. End result would look something like in the picture. Thank you. 

[FrankAT · Accepted solution]

Hi @Justas4478 

this is my sample table:

Sum of Value = SUM('Table'[Value])

Total of Week = CALCULATE([Sum of Value]), ALLEXCEPT('Table', 'Table'[Week]))

Percentage = DIVIDE([Sum of Value], [Total of Week])

 If you use the above measures and conditional formatting your result should like like this:

Take a look at the attached PBIX file.

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[littlemojopuppy]

Hi @Justas4478 ...can you provide some sample data to work with?