Forum Discussion

AH2022's avatar
AH2022
Icon for Helper II rankHelper II
3 years ago
Solved

Executive Summary

Hi All, I am usually asked for statistics by year, for indicators that require measurements. I do it using a table, and I use measures for the labels: Mesure1 = SWITCH(SELECTEDVALUE('TableReport'[La...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
AH2022's avatar
AH2022
Icon for Helper II rankHelper II
3 years ago

Hi Jay,

 

Thank you for your answer, it's really appreciated! 

I started to build a sample data, to ensure confidentiality.

 

Meanwhile, I will try to reformulate my question:

 

On this visual, the rows contain for example,  gifts from CampainA and CampainB

 

And the columns, don’t represent a dimension of just one table (for example fiscal years). 

 I have the measure for the [GiftsExpected22-23] [GiftsReceived22-23] etc

 

 

I am not interested for the moment in the calculations. I have the measures.

 

 I need some advice on how to produce this table. Is it possible to have measures for rows (Gifts from AB, Gifts from Events, Gifts from Stocks etc) and measures for columns (Expected /Received/ Opportunities. And the measures from the columns will need to calculate by row: Expected for : CampainAB, Events, Stocks etc)? I have never done this before .

Thank you.