Display new Value...

[Mahadevaraobc]

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 value of LA and NA).

2nd drill down, if LA is selected it should display all LA countries, if NA selected it should display USA and Canada.

[v-frfei-msft]

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]

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.