Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago
Solved

query mysql to DAX

Hello How do I move this MySQL query to Power BI DAX? SELECT COUNT(total) AS Contador, Sum(cantidad) as canti FROM (SELECT COUNT(*) AS total,sat_reparacion.cantidad FROM sat_reparacion INNER ...
  • Igna's avatar
    Igna
    2 years ago

    Hello,

     

    Not sure of what you are trying to achieve doing this but :

     

    Contador = COUNTROWS(
    FILTER(
        SUMMARIZE(
            FILTER(
                sat_reparacion,
                CALCULATE(SUM(sat_lineas[pvp])) = 0
            ),
            sat_lineas[documento],
            "Contador", COUNTROWS(sat_reparacion),
            "canti", SUM(sat_reparacion[cantidad])
        ),
        [Contador] > 0
    )
)

     

    Igna

Igna's avatar
Igna
Icon for Resolver III rankResolver III
2 years ago

Hello,

 

Not sure of what you are trying to achieve doing this but :

 

Contador = COUNTROWS(
    FILTER(
        SUMMARIZE(
            FILTER(
                sat_reparacion,
                CALCULATE(SUM(sat_lineas[pvp])) = 0
            ),
            sat_lineas[documento],
            "Contador", COUNTROWS(sat_reparacion),
            "canti", SUM(sat_reparacion[cantidad])
        ),
        [Contador] > 0
    )
)

 

Igna