Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Maximum Value with IF Condition

I'm trying to calculate the maximum value with multiple conditions in Power BI.   The dataframe is: Year Company Bond Branch Group Type Value 2016 BANCO DO BRA...
Need Help
  • Kalpavruksh's avatar
    Kalpavruksh
    7 years ago
    Hi,
    Your ALLEXCEPT is removing all context except for Company, which is the opposite of what you want. Put what you want to keep inside ALLEXCEPT.
    CALCULATE (
    MAX ( data[Value] );
    ALLEXCEPT (
        data;
        data[year];
        data[Branch];
        data_segmento_anual[Bond];
        data_segmento_anual[Group];
        data_segmento_anual[Type]
    )
)

     

    The other way to do it is to use ALL to specify the column that you want to be ignored.
    CALCULATE ( MAX ( data[Value] ); ALL ( data[Company] ) )

    Kalpavruksh Technologies | Microsoft Gold Partner
    Denmark | USA | India | Germany

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Kalpavruksh's avatar
Kalpavruksh
Icon for Resolver I rankResolver I
7 years ago
Hi,
Your ALLEXCEPT is removing all context except for Company, which is the opposite of what you want. Put what you want to keep inside ALLEXCEPT.
CALCULATE (
    MAX ( data[Value] );
    ALLEXCEPT (
        data;
        data[year];
        data[Branch];
        data_segmento_anual[Bond];
        data_segmento_anual[Group];
        data_segmento_anual[Type]
    )
)

 

The other way to do it is to use ALL to specify the column that you want to be ignored.
CALCULATE ( MAX ( data[Value] ); ALL ( data[Company] ) )

Kalpavruksh Technologies | Microsoft Gold Partner
Denmark | USA | India | Germany

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
7 years ago

Thanks for the input Kalpavruksh  Let me see how this works :-)