Forum Discussion

imocean's avatar
imocean
Frequent Visitor
5 years ago
Solved

Metrics column breaks filter in visual

Hi there, I've got a quite simple data model where there is a Distributors table, and a Drivers table with lookup to distributor, and a ComplianceRecords table containing all the compliance each dri...
Need Help
  • imocean's avatar
    imocean
    5 years ago

    Got it working - I created custom column on Drivers table to calculate each Driver's metrics. By doing that it filters off those not relevant to the filters. Not sure if it's the best way though. 

imocean's avatar
imocean
Frequent Visitor
5 years ago

Thanks very much jdbuchanan71 . I tried separating to 3 measures but it does the same. The main challenge is that I want to display 0% as well, so with your method I changed on the Compliant % to be

 

Compliant % = IF( [Compliant Count] = 0, 0, DIVIDE ( [Compliant Count], [All Selected Count] ))

 

However adding the 0% made all the rows visible in the visual.