Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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
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
Hi,
You may download my PBI file from here.
Hope this helps.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
96 | |
90 | |
79 | |
67 |
User | Count |
---|---|
151 | |
121 | |
111 | |
107 | |
95 |