Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
This above type Matrix table that I have in power Bi and it is showing that month start from April and end to the March.
In that I have slicer is going to change the matrix table accordingly month they have contain.
I want to get the last column summed value here in our case is March but sometime it can anything like Dec,Jan or feb anything.
So my issue is that I want Dax function which help me to get that value so that I can use in power Bi card.
Solved! Go to Solution.
Hi @Roshan_201295 ,
Generally speaking, the order of Month in the matrix is sorted in alphabetical order. We can find the rank of Month by finding the largest rank.
Here are the steps you can follow:
1. Create measure.
rank =
RANKX(FILTER(ALL('Table'),'Table'[Category]=MAX('Table'[Category])),CALCULATE(MAX([Month])),,ASC)
Last =
CALCULATE(SUM('Table'[Amount]),FILTER(ALL('Table'),'Table'[Category]=MAX('Table'[Category])&&'Table'[rank]=MAXX(FILTER(ALL('Table'),'Table'[Category]=MAX('Table'[Category])),[rank])))
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Roshan_201295 ,
Generally speaking, the order of Month in the matrix is sorted in alphabetical order. We can find the rank of Month by finding the largest rank.
Here are the steps you can follow:
1. Create measure.
rank =
RANKX(FILTER(ALL('Table'),'Table'[Category]=MAX('Table'[Category])),CALCULATE(MAX([Month])),,ASC)
Last =
CALCULATE(SUM('Table'[Amount]),FILTER(ALL('Table'),'Table'[Category]=MAX('Table'[Category])&&'Table'[rank]=MAXX(FILTER(ALL('Table'),'Table'[Category]=MAX('Table'[Category])),[rank])))
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...
vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |