Forum Discussion

Mahadevaraobc's avatar
Mahadevaraobc
Helper II
7 years ago

Display new Value...

Hi All,   I have a dataset with 2 columns, 1 - Region (LA and NA) 2- Country. I would like to display this in a line chart where  1st visual should have 3 values AMS, LA and NA (AMS should have...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Mahadevaraobc ,

 

I created a sample for your reference.. If it doesn't meet your requirement, please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

 

1. Create a calculated table as a slicer table.

 

filter = VALUES(Table1[Region])

2. Create a measure as below.

 

Measure = 
VAR sele =
    SELECTEDVALUE ( 'filter'[Region] )
RETURN
    IF (
        sele = "LA",
        CALCULATE ( SUM ( Table1[values] ), FILTER ( Table1, Table1[Region] = sele ) ),
        CALCULATE ( SUM ( Table1[values] ) )
    )

  • Mahadevaraobc's avatar
    Mahadevaraobc
    Helper II
    7 years ago

    This answers small portion of my question.

    How can i combine values of LA and NA and show that in a line chart with values of LA, NA and Combined.