Forum Discussion
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.
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.
2 Replies
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.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.
