Good day experts.
I want to create a metric in BI that counts purchase orders greater than X value, let's say $500,000.
The table goes something like this:
The expected result in this case is 2, corresponding to purchase orders number 2 and 3.
Thanks a lot!
Go to Solution.
var _purchase = calculate(Sum(Table[MATTER]), filter(allselected(Table), Table[PURCHASE ORDER] = max(Table[PURCHASE ORDER]))
sumx(filter(values(Table[PURCHASE ORDER]), _purchase >50000), calculate(Sum(Table[MATTER])) )
View solution in original post
Thank you very much.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.