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.
I am trying to present the data in a matrix table, but when I input dates into the values field, it only displays the earliest date. It is not displaying individual fields with specific dates.
The third Warranty Period and so on is showing an incorrect date (07-Feb-2022) on all fields when it should be different for each field. Is there a solution to this issue that would enable the correct values to be displayed
ATM matrix table showing me like this
I need like this
Solved! Go to Solution.
Hi , @Anonymous
Based on your description and the screenshots provided, do you want to get the minimum date under different levels under different levels?
If so, you can use the isinscope() function to determine which level you currently belong to to to return different values. The values you need to calculate depend on your filter context, and if you want to ignore filtering at a certain level, you can use calculate([measure],allselected('Table' [column names at this level]))).
For more information, you can refer to :
ISINSCOPE function (DAX) - DAX | Microsoft Learn
ALLSELECTED function (DAX) - DAX | Microsoft Learn
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @Anonymous
Based on your description and the screenshots provided, do you want to get the minimum date under different levels under different levels?
If so, you can use the isinscope() function to determine which level you currently belong to to to return different values. The values you need to calculate depend on your filter context, and if you want to ignore filtering at a certain level, you can use calculate([measure],allselected('Table' [column names at this level]))).
For more information, you can refer to :
ISINSCOPE function (DAX) - DAX | Microsoft Learn
ALLSELECTED function (DAX) - DAX | Microsoft Learn
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@Anonymous , Measure like
MAx(Table[date])
or
calculate(max(Table[Date]), allselected(Table[Column]) )
Still not showing me the correct values
Could you please which column i used here
allselected(Table[Column]) )
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |