How to use TREATAS

[admin_xlsior]

Hi guys,

want to know whether I'm using TREATAS correctly.

So I have these two tables:

and

I create this measure:

Target per dimension =

VAR Regions = VALUES('Default Dimension'[Branch])

VAR Branches = VALUES('Default Dimension'[Region])

RETURN   CALCULATE(

                    SUM(Target'[Target]),

                    TREATAS(Branches, Target'[BRANCH]),

                    TREATAS(Regions, Target'[REGION])           

)

Currently, when I pull Default Dimensios [Region], and pull this measure, the branches listed but the measure column returns empty column

Thanks,

[admin_xlsior · Accepted solution]

Lets forget about this.

It's a typo error, which just realized after 2 hours. 😫

Thanks anyway guys.