% total per week

---

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.