How to make the calculation of a conditional division of the summed total

[Scarthart]

Good afternoon, What I want to do is that the measure prints the total which it is not doing, due to the condition.

I just want the measurement to give me the total correctly.

[v-cgao-msft · Accepted solution]

Hi @Scarthart ,

This is because the total does not have the filters from the row. If you want to get the totals right, you can complete the filters from the entity fields in your code.
like:

Mesesque alcanza SoldosINV =
SUMX (
    SUMMARIZE (
        'Table',
        'Table'[Column1],
        'Table'[Column2],
        'Table'[Column3],
        // Here please complete all the fields(filter) in the table visual.
        "Total",
            VAR Numerador = ...
            VAR Denomiador = ...
            RETURN
                DIVIDE ( Numerador, Denomiador, "..." )
    ),
    [Total]
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Padycosmos]

Could you please explain the calculation in the  VAR Denominator ?

[Scarthart]

@Padycosmos , yes

Measure

This is the measure I use in the denominator

total de materia prima x referencia según la rotacion del producto 2 = IF(ISBLANK([total de materia prima x referencia según la rotacion del producto]),"0",[total de materia prima x referencia según la rotacion del producto])

[Padycosmos]

The total in this case not the total of that column. The result 13.31 is correct . It is (3465.364/260.426). Hope this explains the result.