Forum Discussion
Cummulative Measure for Funnel
Vvelarde After I read this, I checked the model and see that I have a Double Directional relationship between the tables. After set it only Single Directional, the measure works as it have to. Many thanks for have replicated the model, if you didn't I would still be crushing my head for the solution.
Anonymous can you help me with this? I saw this topic from you that is similar but not equal:
http://community.powerbi.com/t5/Desktop/Cumulative-Running-Totals-in-DAX/m-p/42608
Thanks!
Hi, i reproduce your scenario and your formula and works fine. Maybe i miss something more.
Look
Resumen Table (in my case don't have ETAPA 4)
Etapas Table
Measure & Funnel
Let me know where is the difference in your model.
Victor
Lima - Peru
Vvelarde After I read this, I checked the model and see that I have a Double Directional relationship between the tables. After set it only Single Directional, the measure works as it have to. Many thanks for have replicated the model, if you didn't I would still be crushing my head for the solution.
Hi,
This is going back a little bit but I have recreated the measure used above in my own model to sum a field but then want to click on the funnel sections to filter data in other charts.... when I do this it provides the total sum against all supplier names rather than the sum for that individual supplier. I have tried using SUMX but had no success. Please could you assist?
Thanks.
Hi Vvelarde,
I have the same case. I tried your measuer but I received an error message. : Too few arguments were passed to the FILTER function. The minimum argument count for the function is 2.
I have 2 table..
And Etapas:
Funnel:
I need cummulative stages
- Hi. You miss a ) in All(table1)
