Forum Discussion

danidicky's avatar
danidicky
New Member
2 years ago
Solved

Convert Calculated Column to DAX measure

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      
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.