Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I have a dataset like below where TotalPrice gets repeated value .
I only need the first Total Price to sum to get my Total amount in Paginated Report.
Expression :
=Sum(IIf(Fields!PayQuantity.Value > 0 , Fields!TotalPrice.Value, 0))
I have use Column Group to show in the table view. But my Total at the end of rows is not correct. Any help
Paginated Report
The result should be
I wonder if you could write an expression to only sum TotalCost where month = January - That way you will only include it once per year?
Hi Ashmitp869
Can you post what your dataset looks like please? It's hard to understand where those extra rows are coming from.
Thanks
Dan
sample rdl file provided.https://github.com/suvechha/samplepbi/blob/main/sample.rdl
It is because I have multiple TotalCost in different month and year.
24 24 Additional labour for continuity Each 1 437899.08 437899.08 1 437899.08
7 7 Waste disposal Tonne 3051.9 388.66 1186151.454 3051.9 1186151.454 5556.36 2024 June
7 7 Waste disposal Tonne 3051.9 388.66 1186151.454 3051.9 1186151.454 1978.8 2024 July
7 7 Waste disposal Tonne 3051.9 388.66 1186151.454 3051.9 1186151.454 1272.12 2024 August
7 7 Waste disposal Tonne 3051.9 388.66 1186151.454 3051.9 1186151.454 9086.4 2024 June
7 7 Waste disposal Tonne 3051.9 388.66 1186151.454 3051.9 1186151.454 1289.56 2024 May
9 9 Shotcrete Each 1 1745099.88 1745099.88 1 1270835.88
9 9 Shotcrete Each 1 1745099.88 1745099.88 1 1270835.88
9 9 Shotcrete Each 1 1745099.88 1745099.88 1 1270835.88
User | Count |
---|---|
131 | |
71 | |
70 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |