79500719

Date: 2025-03-11 12:24:39
Score: 1.5
Natty:
Report link

i found this solution for my case where i want to calculate orders with only one product, so i changed it like that and it works

Number of orders with one id product = 
CALCULATE(
    DISTINCTCOUNT(Orders[order number]), 
    FILTER(
        SUMMARIZE(Orders, Orders[order number]), 
        CALCULATE(
            DISTINCTCOUNT(Orders[Id_product]), 
            ALLEXCEPT(Orders, Orders[order number])
        )=1
    )
)
Reasons:
  • RegEx Blacklisted phrase (1): i want
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Mateusz Brzuszkiewicz