Forum Discussion

karun_r's avatar
karun_r
Microsoft Employee
8 years ago

ISFILTERED Usage

I have a table structure like below:     Company       Category  FiscalYear  Revenue AdW               Bikes        FY17          200 AdW               Cars         FY17           99 AdW       ...
Need Help
karun_r's avatar
karun_r
Microsoft Employee
8 years ago

Hi Phil,

 

I've tried the approach suggested in your pbi file earlier with my original dataset and it did not work with it. The reason is the existence of multiple fiscal years and it complicates things a bit. For your reference, I've edited the sample pbi file and placed it here.

 

 

 

https://1drv.ms/u/s!AmE9ILAWJzWtgf9JbHAH0Oh_z3MIOw

 

I've added another fiscal year into the mix and created a seperate measure to calculate the number of companies for each range in the different table that you've created. You can see how it displays that few companies exist within range A even though all of them fall under B when the appropriate filters are selected.

 

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi karun_r

 

So how do you want the Fiscal Year to affect your expected result?  Do you want to ignore it and still generate the same values?

  • karun_r's avatar
    karun_r
    Microsoft Employee
    8 years ago

    Ideally, I want one value for each fiscal year. So, yes, the fiscal year must be considered when it assigns the range to the company. The end goal is to have a YoY comparison for each revenue range.