Forum Discussion
Cummulative Formula Not Dynamic
Hello PowerBI Community!
Im totally new to this application, however i have tried to make a report for my project from scratch.
I have watched a couple of Youtube tutorials, but the Cummulative axis doesnt seem to work for me, as i want it.
The Measure looks like this:
I have a lot of slicers as you can see, and i want it to be as dynamic as possible. Means if i press one of the filters, then it would calculate the cummulative of the selected option, and not the whole project as it does right now.
Im not sure if i explained this good enough, im a real noobie.
Would really appreciate any help!
Just an example of when i press one of the filter options:
Saendey
4 Replies
hi - This can we achieved through 2 ways.
1. Through Data Modeling: Get Primary Key in your data tables. Detected the Relationship between the dimension table from where you are using Slicers and relate with the Factual Table from where you are creating KPIs.
2. Through Measures: Use Selected Value DAX function to get it done through Measures.
I will recommend 1st option as this is a good version of accomplishing it.
You can connect me personally to get help in this.
Thanks and Regards
Shalabh Kushwaha
+919454996527
Hi Shalabh Kushwaha!
Thank you very much for your reply.
Im not sure if i understood this correct. Is it possible to contact you on a platform where i can share my screen and explain my problem?
Hi,
Create a Date Table with calculated column formulas for Year, Month name and Month number. Sort the Month name column by the Month number. To the X-axis of your visual, drag Year and Month name from the Calendar Table. Write these measures
Total = sum(Data[sale])
Total YTD = calculate([Total],datesytd('calendar'[date],"31/12"))
Hope this helps.
