Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to create a table/Matrix just with measures?

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!

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi! 

       

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

       

       Diff LY
      SalesMeasure_SalesMeasure_Sales_LY_Diff_%
      StockMeasure_StockMeasure_Stock_LY_Diff_%

       

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

       

      Thanks in advanced, 

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support

    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's avatar
      Anonymous
      Not applicable

      Hi