subtract one percentage from another DAX

[Anonymous]

Hi Experts

I am trying to subtract one % value from another % value and i cannot get BI to give the correct results. The formula is as follows:

FORMAT(CALCULATE([RH Total Revenue PY], FILTER(Management,Management[Level5]="UK Region"))-CALCULATE([RH Total Revenue PY], FILTER(
        'Reporting Hierarchy 2','Reporting Hierarchy 2'[Tweaked Franchise]="INFUSION DEVICES"), FILTER(
        'Reporting Hierarchy 2','Reporting Hierarchy 2'[Tweaked Sub Region]="UK Region")),"#,##0.0%;(#,##0.0%)"),
    

[v-yuta-msft · Accepted solution]

@Anonymous,

You may modify your measure using DAX below and check if it can meet your requirement.

Result =
FORMAT (
    (
        CALCULATE (
            [RH Total Revenue PY],
            FILTER ( ALL ( Management ), Management[Level5] = "UK Region" )
        )
            - CALCULATE (
                [RH Total Revenue PY],
                FILTER (
                    ALL ( 'Reporting Hierarchy 2' ),
                    'Reporting Hierarchy 2'[Tweaked Franchise] = "INFUSION DEVICES"
                        && 'Reporting Hierarchy 2'[Tweaked Sub Region] = "UK Region"
                )
            )
    ),
    "#,##0.0%;(#,##0.0%)"
)

Community Support Team _ Jimmy Tao

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

[Anonymous]

Thanks for th excellent feedback jimmy, let me test the solution