Convert Calculated Column to DAX measure

[danidicky]

Hi all,

can you help me to convert a Calculated Column to DAX measure ?

This is the model:

 and this is the calculated coloumn:

I would convert to measure...

Thanks

[Anonymous · Accepted solution]

Hi @danidicky ,

Please try below dax formula:

Da_produrre =
SUMX (
    Articoli,
    IF (
        [Speciale] = 1,
        IF ( RELATED ( VISART[Effettiva] ) < 0, - RELATED ( VISART[Effettiva] ), 0 ),
        IF (
            ( DIVIDE ( [Bad Dinamico], 240 ) * 30 )
                - RELATED ( VISART[Effettiva] ) <= 0,
            0,
            CEILING (
                ( DIVIDE ( [Bad Dinamico], 240 ) * 30 )
                    - RELATED ( VISART[Effettiva] ),
                [Pz_Pallet]
            )
        )
    )
)

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.