Need help in Dax from tableau to Power BI

[Anonymous]

Hi All,

i want to migrate below formula from Tableau to Power BI Dax,

Days to Pay = sum({INCLUDE [Cocd Docno]: sum([Grss Amnt Usd])}*{INCLUDE [Cocd Docno]: sum([Days to Pay (unweighted)])})/sum([Grss Amnt Usd])

Thanks in Advance..

[amitchandak]

@Anonymous , Try like

sumx(values(table[Cocd Docno]), calculate(sum([Grss Amnt Usd]) *( sum([Days to Pay (unweighted)])/sum([Grss Amnt Usd]))))

Refer to my video of same, if needed

Power BI- Chapter 10- LOD Include (Level Of Details): https://youtu.be/nmBVc2fN6aU