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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

I have made a repro of my scenario - I know what I have in there is not correct to do the job, but I don't know what I need to add in.  There is a PBIX here, and a screen shot below. 

 

When I move the date slider, the total CountOfMatches adjusts accoringly using the measure below. All happy. 

 

EndedContracts = CALCULATE(COUNTROWS(Contracts))

However, when I update the visual level filter on the EndedContracts to only show those dates with less than two ended contracts, the total does not adjust acctoringly.  How do I get the CountOfMatches measure to consider the visual level filter applied to the EndedContracts measure?

 

As per the screen shot below, when I add the filter of < 2 to Ended Contracts, I want the CountOfMatches to become 2. 

 

 

 

 

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)