Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
Thanks. Year is alfready in Rows, could not follow, it will be great if you could share the Pbix fie,
REgards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
79 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
84 | |
70 |