Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Need for help please

  • 1.  Need for help please

    Posted Jan 15, 2021 02:13 PM
    Hello, I am looking for a solution to create a new column to determine the max of the ID_Analyse "by ID_Platform" example below.
    For example the max of ID_Analuse for Id_platform 5 is 858

    ID_ANALYSEID ID_PLATFORM
    797 5
    829 5
    858 5
    798 6
    830 6
    859 6
    816 7
    818 7
    870 7
    809 9
    863 9
    795 10
    803 10
    835 10
    850 10
    872 10
    Thank you in advance for your help


  • 2.  RE: Need for help please

    Top Contributor
    Posted Jan 18, 2021 07:47 AM
    Hi @ilyes ksaier,

    Please use the ALLEXCEPT() function.

    Here is the measure for a calculated column:
    MAX = CALCULATE(MAX('Table'[ID_ANALYSEID]), ALLEXCEPT('Table','Table'[ID_PLATFORM]))

    Hope this helps.

    Thank you,

    ------------------------------
    Vishesh Jain
    MCSA Power BI and Excel
    Emerald Award Dynamic Communities 2019
    Owner
    VR Construction
    ------------------------------



  • 3.  RE: Need for help please

    Posted Jan 18, 2021 09:15 AM

    Try the following measure: (Your data is in 'ILYES DATA' table)

    Max ID_ANALYSEID by ID_Platform =
    CALCULATE(MAX('ILYES DATA'[ID_ANALYSEID ]),
    ALLEXCEPT('ILYES DATA','ILYES DATA'[ID_PLATFORM])
    )


    ------------------------------
    Roberto Mirelman -
    roberto@mirelman.com - United Kingdom
    ------------------------------