Measure with summed up values according to filters

[Anonymous]

Hi all,

I have following issue where I hope to find help here.

I want to create a measure which has the values of a column which is filtered by a contains function.

 To be precise. I have endless financial transactions on numerous subaccounts. Now i want to filter for the main account number which all these suaccounts contain. But I am failing and failing.

So is there a way to do that without editing my data model?

Thanks in advance

BR,

Paul

[Anonymous]

Hi @Anonymous 

share sample data and expected output.

Thanks,

PRavin

[Anonymous]

does this help?

[Anonymous · Accepted solution]

@Anonymous  Try this

Calculate(Sum(table[Column]),filter(table,left(table[Account number],8)="60200000"))

There is also one function stringCOntains. You can try out that also.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.