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.
From the given dataset i need filter out the duplcates and from the output i need to develop the visualization.Plese help me out.
Solved! Go to Solution.
Hi @pabburi,
Here is one way. Create a calculated table using the following code
Table = SUMMARIZE( 'Table1', 'Table1'[ApplicationID] , 'Table1'[Manager] , "Percentage" , MAX('Table1'[Percentage] ) )
Hi @pabburi
For the two rows highlighted for Raju? Do I take it the reason why the 2nd row is kept and the first row is discarded because 60 is higher than 55?
Hi Phil,
Thank you for the time.
Yes applicationID 11 is consider to percantage 60 because of its higher value.
Hi @pabburi,
Here is one way. Create a calculated table using the following code
Table = SUMMARIZE( 'Table1', 'Table1'[ApplicationID] , 'Table1'[Manager] , "Percentage" , MAX('Table1'[Percentage] ) )
It worked.
Thank you Phil
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |