Sum of a value based on set of distinct columns

[revansh]

Hi All,

I am trying to add a measure to calculation sum of a value based on a set of distinct values. My sample dataset is.

NY  ROAD   01-may   10   SYS1

NY  ROAD   02-May   10   SYS2

NY ROAD    02-MAY   10   SYS3

NY  ROAD   03-MAY   10   SYS4

i WANT TO SHOW MY DATA IN REPORT LIKE BELOW.

NY  ROAD  MAY    30 .........(I WANT TO REMOVE ONE ROW WHICH IS A DUPLICATE ,02-MAY)

tHANKS

[v-danhe-msft · Accepted solution]

Hi @revansh ,

You could refer to below measure:

Sample data:

Measure = CALCULATE(SUM(Table1[Column1.4]),FILTER(('Table1'),'Table1'[Column1.3]<>MAX('Table1'[Column1.3])))

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.