Forum Discussion
Filter on Range Measure
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!
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
1 Reply
- v-jiascu-msftMicrosoft Employee
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