Measure error while using VALUES

[kumsha1]

Hi,

VALUES used in below measure calculation is returning error, can someone help to rewrite the DAX...[Status] values can be NULL, 0,100,2,3,4,5....TIA

DAILYCValue = IF(VALUES('VOD'[Status])=2,[CValueTARGET]*100,

IF(VALUES('VOD'[Status])=3,[CValuePLAN]*100,

VALUES('VOD'[Status])))

[Anonymous]

Hi @kumsha1 ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[rbriga]

How about:

SWITCH(

SELECTEDVALUE('VOD'[Status]),

2, [CValueTARGET]*100, --{or, if this isn't a measure, SELECTEDVALUE('VOD'[CValueTARGET])*100}

3, [CValuePLAN]*100,

SELECTEDVALUE('VOD'[Status])

)

[kumsha1]

Hi @rbriga,

this is working ok with the measure values but the measure TOTALS are not displaying...

[rbriga · Accepted solution]

Than you need an itirator.

Try

SUMX(

VALUES('Calendar'[Date]),

SWITCH(

'VOD'[Status],

2, [CValueTARGET]*100, --{or, if this isn't a measure, 'VOD'[CValueTARGET]*100}

3, [CValuePLAN]*100,

'VOD'[Status]

)

You may need to replace VALUES('Calendar'[Date]) by the field you're iterating over (I'm not sure wether it's by date, by products, both, etc...)

[amitchandak]

@kumsha1 , Try like

DAILYCValue = IF(Max('VOD'[Status])=2,[CValueTARGET]*100,
IF(Max('VOD'[Status])=3,[CValuePLAN]*100,
max('VOD'[Status])))

You can also try switch true

[kumsha1]

Hi @amitchandak ,

MAX will work to satify the IF conditions but ELSE will always show MAX(Status) for all other scenarios whereas we need to show actual status.