Filter Function

[egiam]

I have a dax formula that I need to add a filter to.  I tried the following but it didn't work.  Any idea what I'm doing wrong? Thanks!

if( 'FACT CA Contract'[AR Elig] = 0,

0,

 ('FACT CA Contract'[AR Cont] / 'FACT CA Contract'[AR Elig] )

FILTER('AR IND Desc',

OR(

'AR IND Desc'[AR_IND_DESC] = "Assisted",

'AR IND Desc'[AR_IND_DESC] = "None")))

[egiam · Accepted solution]

Thanks I found my error.

[amitchandak]

@egiam , Try like

if( 'FACT CA Contract'[AR Elig] = 0,
0,
calculate( ('FACT CA Contract'[AR Cont] / 'FACT CA Contract'[AR Elig] )
FILTER('AR IND Desc',
OR(
'AR IND Desc'[AR_IND_DESC] = "Assisted",
'AR IND Desc'[AR_IND_DESC] = "None"))) )

But are you trying to create a measure or a column ?

[egiam]

trying to create a measure

[AlexisOlson]

@egiam If it's a measure, you'll need to use an aggregator like SUM.

Customer Sold per Age Group =
CALCULATE (
    DIVIDE (
        SUM ( 'FACT CA Contract'[AR Cont] ),
        SUM ( 'FACT CA Contract'[AR Elig] ),
        0
    ),
    FILTER (
        VALUES ( 'AR IND Desc'[AR_IND_DESC] ),
        'AR IND Desc'[AR_IND_DESC] IN { "Assisted", "None" }
    )
)