Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Visual Level Filter ignored by Measure

I have the below set up (see image). The 934 number is from a measure:    _MeasureTotalSelected = COUNTROWS(VALUES(CUSTOMER)) It's obvious that the 934 does not correlated with the count of the ro...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

In my opinion you should not be dragging Ended Matches to the visual filters.  You should instead be dragging Customer there.  Check the box for specific cutomers and you figure will recompute.  Also, you do not need the CALCULATE() function there.  Just this will work

 

=COUNTROWS(Contracts)

Anonymous's avatar
Anonymous
Not applicable
8 years ago

But I dont want to filter on customers. I want to filter on the number of ended contracts. This is a very simple sample of a far more complex system with thousands of customers and contracts. I want to be able to pick out days and months where we lost X amount of customers, or  > X amount of customers. E.g. Show me the days on which we lost more than 100 customers. In this scenario, the total need to tell me on how many days we lost more than 100 customers. I can achieve this on the total of the visual, but given the data volumes we just want a quick view of this number at the top without scrolling every time and having other columns totalled that dont compute well.