The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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")))
Solved! Go to Solution.
Thanks I found my error.
@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 ?
trying to create a measure
@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" }
)
)
User | Count |
---|---|
78 | |
73 | |
37 | |
30 | |
28 |
User | Count |
---|---|
107 | |
100 | |
55 | |
49 | |
45 |