cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Route11 Member
Member

subtract one percentage from another DAX

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%)"),
    
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: subtract one percentage from another DAX

@Route11,

 

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.

2 REPLIES 2
Community Support Team
Community Support Team

Re: subtract one percentage from another DAX

@Route11,

 

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.

Route11 Member
Member

Re: subtract one percentage from another DAX

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