PATHCONTAINS measure not working
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:
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:
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