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.

     

     

Icey's avatar
Icey
Community Support
6 years ago

Hi altemural ,

 

Please check if this is what you want:

1. Add an Index column in Power Query.

2. Create a measure.

Measure =
VAR RetailIndex =
    MAX ( 'Table'[Index] ) - 12
VAR WholeSalesValue =
    CALCULATE (
        MAX ( 'Table'[Value] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Index] = RetailIndex )
    )
RETURN
    IF (
        MAX ( 'Table'[Type] ) = "Retail",
        MAX ( 'Table'[Value] ) - WholeSalesValue
    )

3. Create a Pie chart or other visuals.

For details, please check the attached PBIX file.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.