Filter on Range Measure

[Flashed]

Hello Guys,

I'm trying to develop a report. I'am using a query from out Dynamics NAV. 

This gives me the follwing information:

GL Account No and Amount. I want to do the following. I want to the amount specified by a range of GL Accounts No.

I want to create a measure.

I've tried the following: 

Recurring Rev = 
Calculate(Sum(RecREV[Amount]);Filter(RecREV[GL AccountNo] >= "8000" .. "8089")

Or

Calculate(Sum(RecREV[Amount]);Filter(RecREV[GL AccountNo] >= "8000" & <= "8089")

Using multiple filters is way to much work if I want to make a very specified range.

I hope you guys can help me out!

[v-jiascu-msft · Accepted solution]

Hi @Flashed,

I would suggest you use the group function. Then the measure will be simple. If you want more details, please provide a dummy sample.

Best Regards,

Dale