I have Item and stock data 2 table.
Item table for keep Item detail.Item Ledger Entry for keep stock transaction. Data is group by Date , Location , Item and Size. How to Create Measure for Count No. of Line Only Sum Qty. by Size is not equal to 0. as Attach Picture.
And Draft Example Output in pbix file as attach Link.PBIX Link : https://drive.google.com/file/d/1eD3pFuIlUQniXoiqcsH7-CeLEdGRqCT9/view?usp=sharingExample ResultData Model
Go to Solution.
@Noppadon , Try a measure like
countx(filter(summarize(Table, Table[location code], table[Item No], "_1", [quantity]),[_1]>0),[_1])
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.