Forum Discussion

Drako3090's avatar
Drako3090
Regular Visitor
9 years ago
Solved

Cummulative Measure for Funnel

Hi everyone, I'm trying to build a measure of cummulative countby a field, to next build a Funnel chart.   My data look like this:     The column [R. Status N°] in the 'Resumen' tab shows ...
Need Help
  • Drako3090's avatar
    Drako3090
    9 years ago

    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.

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Drako3090

 

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

dixon1983's avatar
dixon1983
Regular Visitor
8 years ago

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.