% total per week

[Anonymous]

Hi

Im trying to make a graph that shows how mutch we have registered on every monday every week.

Thats fine, but then i whanto se what the % of the total per week registered (not grand total)

So like week 1: 1 was registered on monday, 10 was registered totaly in week 1.

Same with week 2 and so on.

[Eric_Zhang · Accepted solution]

---

@Anonymous wrote:

Hi

Im trying to make a graph that shows how mutch we have registered on every monday every week.

Thats fine, but then i whanto se what the % of the total per week registered (not grand total)

So like week 1: 1 was registered on monday, 10 was registered totaly in week 1.

Same with week 2 and so on.

---

@Anonymous

You can create a calendar table as below.

Then create measures like 

MondayVal = CALCULATE(SUM(data[value]), dimdate[weekDay]=2)


%total = DIVIDE([MondayVal],SUM(data[value]))

See more details in the attached pbix file.

[Anonymous]

Thank you very mutch Eric

This worked perfectly 😉

Robin