Forum Discussion
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'[Label]),"Measure1",[SalesReceived],0)
Now I am asked in the columns for other calculations. How to do this?
I have scoured the web looking for an answer on this topic and I tried different solutions, with no success. (I found examples for time intelligence measures, which do not meet the need.)
If I insert calculated columns in this table, how do I calculate a column, which has 5 different row contexts (depending on the calculated measure on each row).
Any help would be much appreciated.
Thank you.
I found the answer here :
Solved: calculations (column) on top of existing DAX measu... - Microsoft Power BI Community
Video explaining calculation groups.
(2) Getting Started with Calculation Groups in Power BI - YouTube
(2) Using calculation groups in DAX - Alberto Ferrari - YouTube
3 Replies
Hi AH2022 ,
Have trouble to follow, please share some sample data so that we could so some test.
How to Get Your Question Answered Quickly - Microsoft Power BI Community
Best Regards,
Jay
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.
I found the answer here :
Solved: calculations (column) on top of existing DAX measu... - Microsoft Power BI Community
Video explaining calculation groups.
(2) Getting Started with Calculation Groups in Power BI - YouTube
(2) Using calculation groups in DAX - Alberto Ferrari - YouTube
