Get a total sum of a measure

[Anonymous]

Dear All,

I tried to fix a sum of a measure in a row total, even with tips and tricks from the forum here, but unfortunately without result. Therefore a next attempt for my own situation.

I have created the following measure, but the total is not the sum of the total of the rows. 

Any help is welcome to get this solved.

Thanks!

---------------------------------------

MEASURE:

Due Fee New =

IF (

    SUM([number of rows]) = 0,

    " ",

SUMX(

   VALUES('Dim Customer'[Customer name]),

IF(

    (0.70 - (VAR this_Unique =

    SUM ( [number of rows] )

VAR group_unique =

    CALCULATE (

        SUM ( [number of rows] ),

        ALL ( 'Dim Time'[Hour Period] )

    )

RETURN

    DIVIDE ( this_unique, group_unique )))*100*1.14*21 < 0, "", (0.70 - (VAR this_Unique =

    SUM ( [number of rows] )

VAR group_unique =

    CALCULATE (

        SUM ( [number of rows] ),

        ALL ( 'Dim Time'[Hour Period] )

    )

RETURN

    DIVIDE ( this_unique, group_unique )))*100*1.14*21)))

[Greg_Deckler · Accepted solution]

@Anonymous This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.

Also, sample data would help greatly. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Anonymous]

Thanks Greg for your feedback.

Herewith a data set in text:

Table_Customer:

Customer number	Customer name
1000	ABC
1001	BCD
1002	CDE

Table_Orders

Number of rows	Customer number	Customer name	Order number	Hour period
4	1000	ABC	101607	14:00 – 15:00
1	1000	ABC	102060	14:00 – 15:00
4	1000	ABC	103061	14:00 – 15:00
1	1000	ABC	103400	11:00 – 12:00
1	1000	ABC	104235	16:00 – 17:00
4	1000	ABC	1356413	08:00 – 09:00
94	1000	ABC	1356420	10:00 – 11:00
1	1001	BCD	102074	14:00 – 15:00
1	1001	BCD	102093	14:00 – 15:00
1	1001	BCD	103140	11:00 – 12:00
1	1001	BCD	104288	16:00 – 17:00
17	1001	BCD	1402767	09:00 – 10:00
21	1001	BCD	1402769	09:00 – 10:00
56	1001	BCD	1402802	10:00 – 11:00
14	1001	BCD	1403080	12:00 – 13:00
14	1001	BCD	1404874	17:00 – 18:00
8	1001	BCD	1404876	17:00 – 18:00
25	1001	BCD	1405197	09:00 – 10:00
2	1001	BCD	1405203	09:00 – 10:00
6	1001	BCD	1405407	12:00 – 13:00
7	1001	BCD	1405417	12:00 – 13:00
79	1001	BCD	1405511	12:00 – 13:00
32	1001	BCD	1405554	12:00 – 13:00
44	1001	BCD	1405825	15:00 – 16:00
11	1001	BCD	1405849	15:00 – 16:00
31	1001	BCD	1406136	17:00 – 18:00
10	1001	BCD	1406147	17:00 – 18:00
9	1002	CDE	1408316	16:00 – 17:00
19	1002	CDE	1408976	12:00 – 13:00
2	1002	CDE	1409423	16:00 – 17:00
29	1002	CDE	1410107	12:00 – 13:00
3	1002	CDE	1418665	16:00 – 17:00
29	1002	CDE	1419365	12:00 – 13:00
4	1002	CDE	1419768	16:00 – 17:00
14	1002	CDE	1420500	12:00 – 13:00
2	1002	CDE	1420852	16:00 – 17:00
2	1002	CDE	1431903	16:00 – 17:00
12	1002	CDE	1432583	12:00 – 13:00
9	1002	CDE	1433125	17:00 – 18:00
2	1002	CDE	1440084	16:00 – 17:00
16	1002	CDE	1441484	17:00 – 18:00

I hope this helps for a next step in the solution. Once the formula is rewritten, I wil, check the total sum