Forum Discussion
Calculation at line level in PBI using direct query
Hello all wise heads! 😎 I am struggling with calculation at line level using direct query to dataset. I need to calculate how many "Orders" produce only "Services (TDS)". I have following tab...
Hi amitchandak
I tried your measure and it shows me an error
I also try something like this:
= IF (MAXX (FILTER ( data,data[Sales Voucher Number] = EARLIER ( data[Sales Voucher Number] ) ),
( data[POG Level 1])) = "TDS%",
"No",
"Yes")
it also doesn´t work, because it assigned only YES to all records..
but thank you for your answer!