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,

 

Try this measure

 

=COUNTROWS(FILTER(SUMMARIZE(DateData,DateData[Date],"ABCD",DISTINCTCOUNT(Contracts[Customer])),[ABCD]>2))

This measure will count all dates on which more than 2 customers were lost.  The answer will be one because of all the dates, only on 3 January 2017 did you lost 3 customers.  On the others dates, you only lost one customer each.

 

The value of 2 which has been hard coded can come via a slicer selection.  But before i do that i just wanted to know if my inderstanding of the problem is correct.  If not, then paste your data and show your expected result.

 

You may download the file from here.

 

Will this work?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Yes, that is close, but the 2 needs to come from a visual level filter, or when the visual level filtered is altered, then it needs to impact the total in the measure. 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    Download the file now.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      The slicer works - as per my earlier post, slicers on the page work fine. Go to the visual level filters (under the visualizations tab) on the Contracts matrix. Select some of the dates. The Measure still does not change. 

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        I selected the card visual and then dragged the Date column from the DateDue table to the Visual level filter section.  When i select a date there, the measure responds just fine.