Forum Discussion

altemural's avatar
altemural
Regular Visitor
6 years ago
Solved

Creating a new data

I have two different type datas. I need to create a new graphic by finding the new value between two of them. New table = Whole Sales - Retail.
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi altemural ,

     

    i would create Measures.

    Retail = CALCULATE(SUM('Table'[Value]), 'Table'[Type] = "Retail")

     

    Whole Sales = CALCULATE(SUM('Table'[Value]),'Table'[Type] = "Whole Sales")

     

    Other Sales = [Whole Sales] - [Retail]

    Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.

     

     

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi altemural ,

 

i would create Measures.

Retail = CALCULATE(SUM('Table'[Value]), 'Table'[Type] = "Retail")

 

Whole Sales = CALCULATE(SUM('Table'[Value]),'Table'[Type] = "Whole Sales")

 

Other Sales = [Whole Sales] - [Retail]

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.