Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have following measure that counts distinct clients for a condition:
M1 = CALCULATE(DISTINCTCOUNT(table(client_id), filter(table,table[Served?] ="Yes" ))
I want to show cumulative sum values over months(I have a datedim table) of this measure on a line chart.
Please suggest how can I do it?
My sample pbi file: https://1drv.ms/u/s!Ag919_pO_UKrgQbUO5qfsTPxwfY8?e=gmwvsD
Thanks in advance.
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
@camargos88 thanks it works! If you can answer this for me I'll be very thankful- How can I limit this cumulative sum to the current month on the graph, so that it shows the cumulative sum only till October 2020 not for the rest of the months in the year-nov, dec.
Hi,
You may download my PBI file from here.
Hope this helps.
@Anonymous ,
You can change the measure for it:
M2 = CALCULATE(DISTINCTCOUNT(Test_table[Client id]), FILTER(ALL(Datedim[Date]), Datedim[Date] <= MAX(Test_table[date])), Test_table[Served?] = "Y")
or change you datedim to the max date of test_table.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |