Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Get the value from Column

HI All,

 

i need the vaue which is repeating in the column.

 

Ex: from the below example Using DAX need to get the Value "5" for 2019 and Value "10" for 2018

 

 

Please let me know if you need more details on this.

 

REgards.

 

  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

    Please see the attached file

     

     

     

     

7 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion

    Hi Anonymous 

     

    Try this Measure

    Max Value = MAX( 'Table'[Value] )

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

     

  • Mariusz's avatar
    Mariusz
    Community Champion

    HI Anonymous 

     

    The column will be this.

    Column = CALCULATE( MAX( 'Table'[Value] ), ALLEXCEPT( 'Table', 'Table'[Year] ) ) 

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

  • AlB's avatar
    AlB
    Community Champion

    Hi Anonymous 

    If I understand correctly you want the value with the highest number of appearances. If so,

    1. Place Table1[Year] in the rows of a table visual

    2. Place this measure in the visual:

    Measure =
    VAR AuxTable_ =
        ADDCOLUMNS (
            DISTINCT ( Table1[Value] ),
            "CountCol", CALCULATE ( COUNT ( Table1[Value] ) )
        )
    VAR MaxAppearances_ =
        MAXX ( AuxTable_, [CountCol] )
    RETURN
        SUMX ( AuxTable_, IF ( [CountCol] = MaxAppearances_, [Value], 0 ) )
    

     

    Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.

    Cheers  Datanaut

       

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks. Year is alfready in Rows, could not follow, it will be great if you could share the Pbix fie,

       

      REgards,

      • Mariusz's avatar
        Mariusz
        Community Champion

        Hi Anonymous 

         

        Best Regards,
        Mariusz

        If this post helps, then please consider Accepting it as the solution.

        Please feel free to connect with me.
        Mariusz Repczynski

        Please see the attached file