Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Everyone
I need a measure to retreve the max of ID based on max column and date
I have ID,MAX,DATE columns here my requirement is to remove the duplicate ID's based on max column
should show only the max of id and date
Desired Output
But one more thing i want to remove the max column in visual please give me suggestion for that
Solved! Go to Solution.
Hi @BharathM
Please place the following measure in the filter pane of the table visual, select "is not blank" and apply the filter
FilterMeasure =
VAR MaxMax =
CALCULATE ( MAX ( 'Table'[MAX] ), ALLEXCEPT ( 'Table', 'Table'[ID] ) )
RETURN
COUNTROWS ( FILTER ( 'Table', 'Table'[MAX] = MaxMax ) )
Hi @BharathM
Please place the following measure in the filter pane of the table visual, select "is not blank" and apply the filter
FilterMeasure =
VAR MaxMax =
CALCULATE ( MAX ( 'Table'[MAX] ), ALLEXCEPT ( 'Table', 'Table'[ID] ) )
RETURN
COUNTROWS ( FILTER ( 'Table', 'Table'[MAX] = MaxMax ) )
Thank You so much dude its working
Again Thanks for speed reply
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |