Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have the following matrix
I'm trying to make the sum of the months
But when I add the measure "total current in period", it creates a column for each Month!
Total Current In Period = CALCULATE( SUM('AGG_INFOGER_CTR'[Total]); FILTER( CALCULATETABLE( SUMMARIZE( 'DIM_PERIODO'; 'DIM_PERIODO'[Itemperiodo]; 'DIM_PERIODO'[Period] ); ALLSELECTED('DIM_PERIODO') ); ISONORAFTER( 'DIM_PERIODO'[Itemperiodo]; MAX('DIM_PERIODO'[Itemperiodo]); DESC; 'DIM_PERIODO'[Period]; MAX('DIM_PERIODO'[Period]); ) ) )
The calculation is not wrong but I just wanted the summation of the last column!
Current total in the context of the row
Example:
What would be a dax function? I am a beginner
Thanks!
Solved! Go to Solution.
The issue has nothing to do with DAX. No matter what additional column or measure you add in Value section of the Matrix visual, it will create a column for each month, and it is not possible to show only the last column.
In your scenario, does it return your expected result when you just reserve Total field in the Value section and turn on “Total column”?
Regards,
Lydia Zhang
The issue has nothing to do with DAX. No matter what additional column or measure you add in Value section of the Matrix visual, it will create a column for each month, and it is not possible to show only the last column.
In your scenario, does it return your expected result when you just reserve Total field in the Value section and turn on “Total column”?
Regards,
Lydia Zhang
It Worked, Thanks
@rafaelprog,
Glad to hear the issue is solved, please mark my reply as answer, that way, other community members would easily find the answer when they get same issues.
Regards,
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |