Forum Discussion

ryan_ward's avatar
ryan_ward
New Member
4 years ago
Solved

Overall data measure using allexcept

Hi Guys!  I am trying to create an overall measure which looks at the data which we are currently looking at on the dashboard vs. the entire set of data that we have.  It will be used to extr...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    ryan_ward 
    We can use Allexcept in calcuate columns, but to create a measure try use the following filter.

     

    CCD view measure =
    var ccd_count = CALCULATE(COUNTROWS('Customs Clearance Document'),Filter(Allselected('Customs Clearance Document','[Date Filter]=MAX([Date Filter]))
    var ccd_in_view = [Total CCD Count]
     
    RETURN ccd_in_view/ccd_count
     
    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

ryan_ward , here ccd_count should only consider filter and context of Customs Clearance Document'[Date Filter]

 

if you do not want any filter then use all

ryan_ward's avatar
ryan_ward
New Member
4 years ago

Hi amitchandak Thank you! The only filter that the ccd_count should consider is the date filter, all other filters should not affect the denominator value at all. In this way we can filter the denominator value by the date, while the numerator value will be affected by all filters on the dashboard. Sorry if I did not understand your response.