Forum Discussion
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...
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_countPaul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
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.
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Amazing! Thank you so much to everyonewho has assisted with this! 🙂