Forum Discussion
Show Funnel Visualization Data in a seperate Table
Carina,
You would need to calculate percentage of first and percentage of before using DAX, then create table visual to show these values. There is an example for your reference.
Percent of First = Table3[Amount]/CALCULATE(SUM(Table3[Amount]),FILTER(Table3,Table3[Index]=1))
Previous = CALCULATE(SUM(Table3[Amount]),FILTER(Table3,Table3[Index]=EARLIER(Table3[Index])-1))
Percent of Previous = IF(ISBLANK(Table3[Previous]),0, Table3[Amount]/Table3[Previous])
Regards,
Lydia
Carina,
You would need to calculate percentage of first and percentage of before using DAX, then create table visual to show these values. There is an example for your reference.
Percent of First = Table3[Amount]/CALCULATE(SUM(Table3[Amount]),FILTER(Table3,Table3[Index]=1))
Previous = CALCULATE(SUM(Table3[Amount]),FILTER(Table3,Table3[Index]=EARLIER(Table3[Index])-1))
Percent of Previous = IF(ISBLANK(Table3[Previous]),0, Table3[Amount]/Table3[Previous])
Regards,
Lydia
Anonymous
Thank you very much for your help!
I managed to calculate the percentage of the first, but the formular for the previous does not work for me.
For some reason the EARLIER Formular does not work. The error message I get is "EARLIER/EARLIEST verweist auf einen früheren Zeilenkontext, der nicht vorhanden ist." - the earlier formular refers to a row context which is not available.
Do you have any idea what the reason for this could be?
Best regards,
Carina
Carina,
Right click your table, select "New column", then apply the DAX I provided.
Regards,