Forum Discussion
Chapin4u
8 years agoMicrosoft Employee
Running Total for no Calendar table
Hi, I need help to create the running total of the third column of the left image. I do not have a calendar table, I just have Year Table on the right side of the image. The measure the third column...
- 8 years ago
Hi, here it's
Tks
- 8 years ago
Hi,
You may refer to my solution in this PBI file. Since your "% Countries vs World" measure does not add up to 100%, your and my measure do not match for the first country i.e. Italy (see image below). Thereafter my measure returns the correct result.
Hope this helps.
Chapin4u
8 years agoMicrosoft Employee
Hi, here it's
Tks
Ashish_Mathur
8 years agoSuper User
Hi,
You may refer to my solution in this PBI file. Since your "% Countries vs World" measure does not add up to 100%, your and my measure do not match for the first country i.e. Italy (see image below). Thereafter my measure returns the correct result.
Hope this helps.
- Chapin4u8 years agoMicrosoft Employee
Really a great solution, thank you!
- Ashish_Mathur8 years agoSuper User
You are welcome.