DAX Formula Help

[RajK2]

Dear Team

I have data table so i want to change line chart using the formulas and working well for single region.

if i try to apply filter multiple region doesn't support me. how to resolve this.

Example if i apply filter for Amercia + Denmark then value should show $ value 70,000 and % value = 1.108

TEST =

VAR Val =

ROUND(CONVERT(VALUES('Data'[Value]),DOUBLE),3)

VAR Defines = IF(

           VALUES('Data'[Type])="- PM $",Val)

RETURN Defines

Region	Type	Value
America	PM %	0.32
America	PM $	40000
Denmark	PM %	0.788
Denmark	PM $	30000
Russia	PM %	0.822
Russia	PM $	430494

Thanks

[Greg_Deckler · Accepted solution]

@RajK2 Not sure how a line chart factors into this and not sure why you need anything other than a simple SUM?? See PBIX attached below.