Get the value from Column

[Anonymous]

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.

[AlB]

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  

[Anonymous]

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

REgards,

[Mariusz · Accepted solution]

Hi @Anonymous 

Best Regards,
Mariusz

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

Please feel free to connect with me.

Please see the attached file

[jmuniz]

Thanks for the tip @Mariusz !

[Mariusz]

Hi @jmuniz,

No problem! 

Best Regards,
Mariusz

Please feel free to connect with me.

[Mariusz]

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]

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.