Forum Discussion

arvindjha2050's avatar
arvindjha2050
New Member
1 year ago
Solved

ConversionRate

I have two tables Requirement is when i select Egypt and Year: 2023 and STD : STD23 It should show 100 Requirement is when i select Egypt and Year: 2023 and STD : STD24 It should show 2...
Need Help
  • mickey64's avatar
    mickey64
    1 year ago

    Step 0: I use your DATA below. (Date:yyyy/mm/dd)

    'Table1'

    'Table2'

     

    Step 1: I make a 'CountryTable'. 

    CountryTable = SUMMARIZE('Table1','Table1'[Country])

     

     Step 2: I add 2 relationships below.

    Step 3: I make 3 measures below.

    M_CR = MAXX(FILTER('Table1','Table1'[STD]=SELECTEDVALUE(Table1[STD])),'Table1'[CR])

    M_Sales = MAXX(FILTER('Table2','Table2'[Year]=SELECTEDVALUE('Table2'[Year])),'Table2'[Sales])

    M_Total = VAR SelectedTable = SUMMARIZE('CountryTable','CountryTable'[Country],"Sales",[M_Sales],"CR",[M_CR])
            RETURN SUMX(SelectedTable,[Sales]*[CR])

     

    Step 4: I make 3 slicers, 2 tables and a card visual.

     

mickey64's avatar
mickey64
Super User
1 year ago

Step 0: I use your DATA below. (Date:yyyy/mm/dd)

'Table1'

'Table2'

 

Step 1: I make a 'CountryTable'. 

CountryTable = SUMMARIZE('Table1','Table1'[Country])

 

 Step 2: I add 2 relationships below.

Step 3: I make 3 measures below.

M_CR = MAXX(FILTER('Table1','Table1'[STD]=SELECTEDVALUE(Table1[STD])),'Table1'[CR])

M_Sales = MAXX(FILTER('Table2','Table2'[Year]=SELECTEDVALUE('Table2'[Year])),'Table2'[Sales])

M_Total = VAR SelectedTable = SUMMARIZE('CountryTable','CountryTable'[Country],"Sales",[M_Sales],"CR",[M_CR])
        RETURN SUMX(SelectedTable,[Sales]*[CR])

 

Step 4: I make 3 slicers, 2 tables and a card visual.

 

arvindjha2050's avatar
arvindjha2050
New Member
1 year ago

Thanks a lot Mickey for the same , it works