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 yo...
Need Help
  • 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

     

     

     

     

AlB's avatar
AlB
Community Champion
6 years ago

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

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

       

       

       

       

      • jmuniz's avatar
        jmuniz
        Frequent Visitor
        6 years ago

        Thanks for the tip Mariusz !