Forum Discussion

ING_BT's avatar
ING_BT
Icon for Helper I rankHelper I
3 years ago

Divide and Filter by Row condition

Hello !  I'm trying a simple calculation - I can't quite figure it out   In the example below - I need a measure whith divides the sum ONLY when the ROW SUM is higher than 500.   If I do a "If...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi ING_BT ,

 

Please try:

Measure = 
IF(
    HASONEVALUE('Table'[Letters]),
    DIVIDE([Sum of Volume B],[Sum of Volume A]),
    VAR _B = 
    SUMX(
        FILTER(
            SUMMARIZE(
                'Table',
                'Table'[Letters],
                "B",[Sum of Volume B]
            ),
            [B]>500
        ),
        [B]
    )
    VAR _A =
    SUMX(
        FILTER(
            SUMMARIZE(
                'Table',
                'Table'[Letters],
                "A",[Sum of Volume A],
                "B",[Sum of Volume B]
            ),
            [B]>500
        ),
        [A]
    )
    RETURN
    DIVIDE(_B,_A)
)

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