Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
below is my dataset (as an example), I want to calculate how many products with lowest price sold of each distributor, same as SummaryTable1, meanwhile having another SummaryTable2 to show me what are the cases.
thank you so much for helping me out!
my initial attempt was to create an array of numbers (each product code with min price) and then use this array as a criterion to filter in my dataset when the product is the same and the price is equal to the min price, but of course failed. I don't quite understand the concept of PBI when the array is relevant to a certain column (same product).
Sincerely,
Nate
Solved! Go to Solution.
thanks Sam. i tried myself and succeeded.
i put it here if anyone is interested.
You may add a calculated column first.
Column = IF ( 'Table'[Price] = MINX ( FILTER ( 'Table', 'Table'[Product] = EARLIER ( 'Table'[Product] ) ), 'Table'[Price] ), 1 )
thanks Sam. i tried myself and succeeded.
i put it here if anyone is interested.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |