Forum Discussion

Spetter's avatar
Spetter
Advocate IV
8 years ago

Cumulative total

Hi,   I am making a cumulative percentage and I am using the DAX pattern to do this. However, I need a slight customization. If I select Q2 I want the cumulative percentage to cumulate the percent...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Your question is not clear.  What does the green column respresent?  When you select Q2, why should Q3 show 21.8%.  Please share a dataset and explain the business question.  Once we can compute the correct figures in a Table, creating a visual should be very simple.

Spetter's avatar
Spetter
Advocate IV
8 years ago

Hi

 

I have uploaded the file to

https://www.dropbox.com/s/kgojyt35s0i97d1/test.pbix?dl=0

 

 

Below you can see the datamodel and how I have used this in the dashboard

 

 

In the chart below the endresult should be instead:

  • dark column Q3: 22,2%
  • dark column Q4: 22,2% + 30,5%: 52,7%