PATHCONTAINS measure not working

Discussion

I've used this method before so I don't know why it isn't working now. I have my qbo transaction table and a mapping table. The mapping table looks something like this:

Mapping table

I joined the tables on qbotransactiondetail[account name]:mapping[child] with mapping being the one side of one/many relationship.

I have my measure,

Actuals =

CALCULATE(

   SUM(qbotransactiondetail[amount]),

   REMOVEFILTERS(Mapping[Hierarchy]),

   PATHCONTAINS(

Mapping[Hierarchy],

SELECTEDVALUE(Mapping[Child])

   )

)

When I create my visual, I get this:

Visual

When it should be $400 for Consulting Services.

What's going on? I checked and there are no spaces etc. screwing up the text strings.

Thanks in advance.

Posted Jul 6, 2026, 9:04 PM UTC

32
Loading comments…