I have a sample table like this:
(Assuming the rows go on and on to >1000 rows with multiple values)
The account IDs are not in number format because some accounts have letters like the example above.
I want to create a new measure to summarise all the amounts for accounts starting with 5 (ie: 5000, 5001, etc)
Currently my measure looks like this:
Measure = CALCULATE(SUM(TEST[Amount]),TEST[Account]="5000"&&TEST[Account]="5001"&&TEST[Account]="5002" ... (and so on)
I wonder if there is a way to filter there 5xxx accounts in my formula? I tried TEST[Account]="5???" but it does not work.
Go to Solution.
Hi @voiciK , Try this:
Measure = CALCULATE(SUM(TEST[Amount]),FILTER(TEST , LEFT('TEST'[ACCOUNT],1) = "5"))
View solution in original post
Thank you 😄
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!