Forum Discussion

Flashed's avatar
Flashed
Frequent Visitor
8 years ago
Solved

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.

    Filter_on_Range_Measure

     

    Best Regards,

    Dale

     

     

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft 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.

    Filter_on_Range_Measure

     

    Best Regards,

    Dale