Forum Discussion

KamphuisB's avatar
KamphuisB
Frequent Visitor
8 years ago
Solved

Funnel Form step analysis Calculated Metric DAX

Hi all,   Currently i am working on a dashboard and i want to make a dynamic table in which i can show a form funnel(based on choice in slicer and how it performs. I can't figure out how to do the ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 years ago

    KamphuisB,

    Add an index column in your table in Query Editor of Power BI Desktop.


    Then create the following columns in  your table.

    Step/step1 = DIVIDE(Table[Count], CALCULATE(SUM(Table[Count]),FILTER(Table,Table[Steps]="A")))
    Step/previous step = 
var previous= CALCULATE(FIRSTNONBLANK(Table[Count],Table[Count]),FILTER(Table,Table[Index]=EARLIER(Table[Index])-1) )
return
IF(ISBLANK(previous),1, divide(Table[Count],previous))



    Regards,
    Lydia

KamphuisB's avatar
KamphuisB
Frequent Visitor
8 years ago

Sorry but step/pstep did not work as a calculated column in my case.. Last weeks i was on holiday so i couldn't answer on this ticket. I will look again into this matter and try it somehow with a calculated metric.

 

kind regards,

 

Bas Kamphuis

Anonymous's avatar
Anonymous
Not applicable
8 years ago

KamphuisB,

I have sent your modified PBIX file via Private Message.

Regards,

Lydia