Forum Discussion
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
- Greg_Deckler
Community Champion
Use a Table or Matrix visualization?- AnonymousNot 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 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,
- v-frfei-msft
Community 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.
- AnonymousNot applicable
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: