How to create a table/Matrix just with measures?

[Anonymous]

Hi Guys,

I’m stuck and hoping that someone can help me 😊

I want to create a Table or Matrix, that contains measures.  Like this:

	€	Diff LY
Sales	Measure_Sales	Measure_Sales_LY_Diff_%
Stock	Measure_Stock	Measure_Stock_LY_Diff_%

To create these measures, I did it like this:

First column:
Measure_Sales= sum(Table_Sales[Total])

Measure_Stock=Sum(Table_Sales[Stock])

Second column:

Measure_Sales_LY= CALCULATE ([Measures_Sales], SAMEPERIODLASTYEAR (Calendar[DATE])

Measure_Sales_LY_Diff= IF ( ISBLANK ( [Measure_Sales_LY ), BLANK (), ( [Measure_Sales] - [Measure_Sales_LY] ) )

Measure_Sales_LY_Diff_%= Measure_Sales_LY_Diff/Measure_Sales_LY

Measure_Stock_LY= CALCULATE ([Measures_Stock], SAMEPERIODLASTYEAR (Calendar[DATE])

Measure_Stock_LY_Diff = IF ( ISBLANK ( [Measure_Stock_LY ), BLANK (), ( [Measure_Stock] - [Measure_Stock_LY] ) )

Measure_Stock_LY_Diff_%= Measure_Stock_LY_Diff/Measure_Stock_LY

How can I create something like this?

I’ve tried creating a DAX table adding my measures, but then the information is static, it must be dynamic, changed by period of time selected.

Thanks!

[v-frfei-msft]

Hi @Anonymous ,

Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive for Business and share the link here.

[Anonymous]

Hi v-frfei-msft, 

Thanks for your reply. Of course, I can share my pbix: LINK

I attached a screen shot of my pbix too: 

[Greg_Deckler]

Use a Table or Matrix visualization?

[Anonymous]

Hi! 

It doesn't matter if it's a table or matrix visualization. In fact, I just need a visualization like these: 

	€	Diff LY
Sales	Measure_Sales	Measure_Sales_LY_Diff_%
Stock	Measure_Stock	Measure_Stock_LY_Diff_%

But... I'm still stuck and I don't know how do it..

Thanks in advanced,