Measure totals correct in column but not in Row

[AWF14978]

Hello,

I appreciate this is a common error, so please link away if there is already I thread I couldnt seem to find it.

I have the below function that correctly totals in the columns but does not total correctly within the rows... (See below Screenshot & Measure below)

Any help/Guidance would be fantastic!

Kind regards,

AF

LNS =
VAR Table1 =
    SUMMARIZE (
        Metrics,
        Metrics[Venue[VenueNameOfficial]]],
        Metrics[Business Date[Fiscal Week]]],
        "Melt", [LNS]
    )
RETURN
    SUMX ( table1, [LNS] )

[v-yangliu-msft · Accepted solution]

Hi  @AWF14978 ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Measure =
var _table1=
SUMMARIZE(
    'Table2','Table2'[Group1],"Value1",[LMS])
var _table2=
SUMMARIZE(
    'Table2','Table2'[Date],"Value2",[LMS])
return
IF(
    NOT(HASONEVALUE('Table2'[Date])),SUMX(_table2,[Value2]),
    IF(
        NOT(HASONEVALUE('Table2'[Group1])),SUMX(_table1,[Value1]),[LMS]))

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly