Forum Discussion
ISFILTERED Usage
I think the reason for why only the range B is appearing in the table is because of the MAX function used in the Range definition, is my intuition correct ? Phil_Seamark
HI karun_r
What is the expected result you are after? Are you trying to show a differnet number fo the [Count of Company] from the visual table on the right?
Yes. Ideally, since we have selected few categories, the table on the right should show the number of companies that fall within each range value and it should take all the filters provided into context when it determines the range using the revenue. I've been struggling with figuring out how to take the "categories" into context without messing up the range assignments.
In the example pbi, with the filters as in the attached image, my ideal result would look like
Range #Companies
B 1
C 1
Phil_Seamark, To give more context on what I'm doing, I've edited the sample pbi file and shared it here.
https://1drv.ms/u/s!AmE9ILAWJzWtgf9I75oB116mVNJi-Q
I added data for one more fiscal year and ideally what I am looking for is a comparison of number of customers in each range between fiscal years.
So my initial step was to get the range definition working for atleast 1 fiscal year then I can worry about comparing ranges from both fiscal years.
Hi karun_r
I think I have what you are after. It involves a disconnected table with a new measure called [# Companies]