Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good day, I need a measure that counts the number of lowest prices from each supplier, as in the table on the right:
Thanks
Solved! Go to Solution.
Hi @MatheusFraga ,
Please try code as below to create a measure.
Qt.Of best price =
VAR _SUMMARIZE =
SUMMARIZE (
FILTER (
ADDCOLUMNS (
'Table',
"Lowest Price", CALCULATE ( MIN ( 'Table'[Price] ), ALLEXCEPT ( 'Table', 'Table'[Product] ) )
),
[Price] = [Lowest Price]
),
[Supplier],
[Product],
[Price]
)
RETURN
COUNTAX ( _SUMMARIZE, [Product] ) + 0
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @MatheusFraga
Is there any creiteria that define number less then x is lower numbe
Yes, the column Product. I need the lowest price for each Product, then rank the Suppliers
Hi @MatheusFraga ,
Please try code as below to create a measure.
Qt.Of best price =
VAR _SUMMARIZE =
SUMMARIZE (
FILTER (
ADDCOLUMNS (
'Table',
"Lowest Price", CALCULATE ( MIN ( 'Table'[Price] ), ALLEXCEPT ( 'Table', 'Table'[Product] ) )
),
[Price] = [Lowest Price]
),
[Supplier],
[Product],
[Price]
)
RETURN
COUNTAX ( _SUMMARIZE, [Product] ) + 0
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
57 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |