Wrong Total in Table

Something like this approach may also work for you.

Measure = 
var _vTable = 
SUMMARIZE(
    'Table',
    'Table'[License],
    "__count", COUNT('Table'[License])
)
var _multiplier = 
SWITCH(
    SELECTEDVALUE('Table'[License]),
    "PPU", 22.5,
    "Pro", 13.1,
    "Free", 13.1,
    BLANK()
)
RETURN
SUMX(
    _vTable,
    [__count] * _multiplier
)

This creates a virtual table that summarzes the intial table by licence with the count of each license. The SWITCH _multiplier variable provides the correct multiplier for each licence type. 
The return statement sums the lines of the virtual table, multiplying the licence counts by the correct amount. 

Suhel_Ansari  So, when multiple rows are in scope like in the total row, the SELECTEDVALUE is going to return BLANK. You will need to use ADDCOLUMNS to add your calculation to a table variable and then use SUMX across that table for the total row.

Hi Suhel_Ansari Since no sample file was shared, it’s difficult to write the exact DAX in one go. Please try the following and let me know how it goes.

License Cost = 
VAR CurrentCount = COUNT('Table'[EmailID])
VAR Multiplier = 
    SWITCH(
        SELECTEDVALUE('Table'[License]),
        "PBI_PREMIUM_PER_USER", 22.50,
        "Power BI Pro", 13.10,
        "Free Users", 13.10,
        BLANK()
    )
VAR RowResult = CurrentCount * Multiplier

// For Total row - iterate and calculate each license type
VAR TotalResult = 
    SUMX(
        VALUES('Table'[License]),
        VAR LicCount = CALCULATE(COUNT('Table'[EmailID]))
        VAR LicMultiplier = 
            SWITCH(
                'Table'[License],
                "PBI_PREMIUM_PER_USER", 22.50,
                "Power BI Pro", 13.10,
                "Free Users", 13.10,
                0
            )
        RETURN LicCount * LicMultiplier
    )

RETURN
IF(
    ISINSCOPE('Table'[License]),
    RowResult,
    TotalResult
)

Thanks 

Please try the following formula:

License Cost :=
VAR Lic   = SELECTEDVALUE ( 'Table'[License] )
VAR Users = DISTINCTCOUNT ( 'Table'[EmailID] )
VAR Price =
    SWITCH (
        Lic,
        "PBI_PREMIUM_PER_USER", 22.5,
        "Power BI Pro",         13.1,
        "Free Users",           0,
        0
    )
RETURN
IF (
    ISINSCOPE ( 'Table'[License] ),
    Users * Price,
    SUMX ( VALUES ( 'Table'[License] ), CALCULATE ( Users * Price ) )
)

Hi Suhel_Ansari,

Thank you Royel GeraldGEmerick cengizhanarslan and jgeddes for ypur response to the query.

Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
Please feel free to reach out Microsoft fabric community forum.

Hi Suhel_Ansari,

We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

If you need any further assistance, feel free to reach out.

Thank you for being a valued member of the Microsoft Fabric Community Forum!