Blank total from measure with HASONEVALUE

Thank you SamWiseOwl for your response. The solution didn't work for me, but I got some inspiration from it and worked further on my DAX to find a solution.

HASONEVALUE filters down to one distinct value (HASONEVALUE - DAX Guide), so having multiple lines was not the problem. The problem was I was getting 0 for some value, which I conditionally made blank at the end. The DAX was returning lines with different currencies, some with 0 balance (or that's how I understand it). So, I had to first remove those lines with balance = 0.

Anonymous, anyone with the link can access the file, so I'm not sure why you can't 🙂 But my problem is (was) that my DAX made the total BLANK when I used HASONEVALUE on currency. It looked like there was only one currency, but there were more.

Here is the DAX that gave me what I wanted, which I'm using now in the report. If you guys can suggest improvements to it, that would be great. (Please note that the measures used here come from on-prem SSAS cube).

Balance - Invoice = 
VAR _CurrencyCount =
    SWITCH
    (
        MAX('Due Filter'[Due]),
        "All",          COUNTX
                        (
                            FILTER
                            (
                                SUMMARIZE('Fact - Payment', 'Fact - Payment'[Currency_Key], "Balance", [Invoice Balance]),
                                [Balance] <> 0
                            ),
                            [Currency_Key]
                        ),
        "Today",        COUNTX
                        (
                            FILTER
                            (
                                CALCULATETABLE
                                (
                                    SUMMARIZE('Fact - Payment', 'Fact - Payment'[Currency_Key], "Balance", [Invoice Balance]),
                                    FILTER('Date - Due', 'Date - Due'[Due Date] = TODAY())
                                ),
                                [Balance] <> 0
                            ),
                            [Currency_Key]
                        ),
        "In 7 days",    COUNTX
                        (
                            FILTER
                            (
                                CALCULATETABLE
                                (
                                    SUMMARIZE('Fact - Payment', 'Fact - Payment'[Currency_Key], "Balance", [Invoice Balance]),
                                    FILTER('Date - Due', 'Date - Due'[Due Date] >= TODAY() && 'Date - Due'[Due Date] <= DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()) +  7))
                                ),
                                [Balance] <> 0
                            ),
                            [Currency_Key]
                        ),
        "In 14 days",   COUNTX
                        (
                            FILTER
                            (
                                CALCULATETABLE
                                (
                                    SUMMARIZE('Fact - Payment', 'Fact - Payment'[Currency_Key], "Balance", [Invoice Balance]),
                                    FILTER('Date - Due', 'Date - Due'[Due Date] >= TODAY() && 'Date - Due'[Due Date] <= DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()) + 14))
                                ),
                                [Balance] <> 0
                            ),
                            [Currency_Key]
                        ),
        "In 30 days",   COUNTX
                        (
                            FILTER
                            (
                                CALCULATETABLE
                                (
                                    SUMMARIZE('Fact - Payment', 'Fact - Payment'[Currency_Key], "Balance", [Invoice Balance]),
                                    FILTER('Date - Due', 'Date - Due'[Due Date] >= TODAY() && 'Date - Due'[Due Date] <= DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()) + 30))
                                ),
                                [Balance] <> 0
                            ),
                            [Currency_Key]
                        ),
        "Overdue",      COUNTX
                        (
                            FILTER
                            (
                                CALCULATETABLE
                                (
                                    SUMMARIZE('Fact - Payment', 'Fact - Payment'[Currency_Key], "Balance", [Invoice Balance]),
                                    FILTER('Date - Due', 'Date - Due'[Due Date] < TODAY())
                                ),
                                [Balance] <> 0
                            ),
                            [Currency_Key]
                        )
    )

VAR _InvBal =
    SWITCH
    (
        MAX('Due Filter'[Due]),
        "All"       , [Invoice Balance],
        "Today"     , CALCULATE([Invoice Balance], FILTER('Date - Due', 'Date - Due'[Due Date] = TODAY())),
        "In 7 days" , CALCULATE([Invoice Balance], FILTER('Date - Due', 'Date - Due'[Due Date] >= TODAY() && 'Date - Due'[Due Date] <= DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()) +  7))),
        "In 14 days", CALCULATE([Invoice Balance], FILTER('Date - Due', 'Date - Due'[Due Date] >= TODAY() && 'Date - Due'[Due Date] <= DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()) + 14))),
        "In 30 days", CALCULATE([Invoice Balance], FILTER('Date - Due', 'Date - Due'[Due Date] >= TODAY() && 'Date - Due'[Due Date] <= DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()) + 30))),
        "Overdue"   , CALCULATE([Invoice Balance], FILTER('Date - Due', 'Date - Due'[Due Date] < TODAY()))
    )

RETURN
IF
(
    HASONEVALUE('Fact - Payment'[Currency_Key]),
    IF(_InvBal = 0, BLANK(), _InvBal),
    IF
    (
        _CurrencyCount = 1,
        IF(_InvBal = 0, BLANK(), _InvBal),
        BLANK()
    )
)

Thank you again.

Regards, VSP