Forum Discussion
olimilo
Post Prodigy
Post ProdigyVios are Using FILTER() with data from 2++ tables
So, I'm trying to do this measure using DAX: Initial (NY) =
CALCULATE(
DISTINCTCOUNT(Vios[InsNo])
, FILTER(Vios, Violations[MG Type] = "New York") && FILTER('Scope', 'Scope'[Scope] = "Full ...
What you want is possible like this:
Initial (NY) = CALCULATE ( DISTINCTCOUNT ( Vios[InsNo] ), FILTER ( Vios, Violations[MG Type] = "New York" ), FILTER ( 'Scope', 'Scope'[Scope] = "Full Scope" ) )separate CALCULATE setfilter arguments are "AND" together.
mattbrice
Solution Sage
Solution SageWhat you want is possible like this:
Initial (NY) =
CALCULATE (
DISTINCTCOUNT ( Vios[InsNo] ),
FILTER ( Vios, Violations[MG Type] = "New York" ),
FILTER ( 'Scope', 'Scope'[Scope] = "Full Scope" )
)separate CALCULATE setfilter arguments are "AND" together.
olimiloThank you! I'll check if I got the correct numbers and get back to this