Help with DAX to display funnel

[Anonymous]

Hello,

Im trying to display a funnel in my Power BI report that is based on a datalist from excel. So the logic is this, in column B from a dropdown list you choose from 6 different status. If you choose for Row 1 Status 2 then a formula will calculate and insert into the table 1 in Status 1 and 1 in Status 2. This means that the No. 1 have gone from Status 1 to now being in Status 2. But I still need to know the total amount of activities that have been in one specific Status. 

Is this possible to do with DAX-formulas? 

Thanks!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous]

Hello @Ashish_Mathur ,

THank you very much, this seems to be working great! 

/A

[Ashish_Mathur]

You are welcome.