How to use TREATAS

Question

Hi guys,want to know whether I'm using TREATAS correctly.So I have these two tables:and&nbsp;&nbsp;&nbsp;I create this measure:Target per dimension = VAR Regions = VALUES('Default Dimension'[Branch])VAR Branches = VALUES('Default Dimension'[Region])RETURN&nbsp;&nbsp; CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SUM(Target'[Target]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TREATAS(Branches, Target'[BRANCH]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TREATAS(Regions, Target'[REGION])&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;Currently, when I pull Default Dimensios [Region], and pull this measure, the branches listed but the measure column returns empty column&nbsp;Thanks,

admin_xlsior · Accepted Answer

Lets forget about this.It's a typo error, which just realized after 2 hours.&nbsp;😫&nbsp;Thanks anyway guys.

Forum Discussion

How to use TREATAS

1 Reply

Related content

TREATAS

TREATAS in DAX

TREATAS with Event Database

TREATAS

The TREATAS Function