DAX For Measure

[Anonymous]

Hello,

I have table as below,

And I already done some calculation.

I want do the proportion surviving as blow, column G is the formulare of proportion surviving. And it should be able to filtering by type.

You can download the pbix file from here.

Thanks.

[Keerthika]

Hi @Anonymous 

Could you explain about formulae column. Are E and F parameters correct?

[Anonymous]

Hi @Keerthika ,

Column E=1-Column D, and Column G is Column F's formular. You can download the pbix file here. Thank you. 

[Keerthika]

Hi @Anonymous ,

You can try out this link

https://community.powerbi.com/t5/Desktop/DAX-getting-previous-value/m-p/490970#M228801

Thanks.

[TeigeGao]

Hi @Anonymous ,

I can't access your shared file, I don't have permission.

Best Regards,

Teige

[Anonymous]

Hi @TeigeGao ,

Please try this one pbix.file. Thank you.