Forum Discussion
DAX Formula Help
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
Anonymous 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.
1 Reply
Anonymous 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.