Forum Discussion
Gikho
6 years agoFrequent Visitor
Running rate
Hello, I'm trying to get the cumulative rate of a measure without succes. I have 2 tables with both a week column, and the number of orders on a second column. I created a measure to get a ratio...
- 6 years ago
Hi Gikho ,
You could replace "ALLSELECTED('Table 1'[Week])" with "ALL('Table 1')" in your second measure.
Here is the result.
v-eachen-msft
6 years agoCommunity Support
Hi Gikho ,
You could replace "ALLSELECTED('Table 1'[Week])" with "ALL('Table 1')" in your second measure.
Here is the result.
- Gikho6 years agoFrequent Visitor
Thanks you for the solution !
I added a year column to have the running rate by year, but the results are indentical by year, is there a filter to add in the measure?