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.
Hi All,
I want to calculate the latest outstanding value corresponding to some columns (eg: Age_profile , Status) provided that the data is for whole of previous week and the file type is OS.
I'm using below measure to calculate the outstanding volume
Solved! Go to Solution.
Hi @Anonymous ,
Measure works on visual level. In the first measure, you used filter(table), so the max() function wouldn't give you the max value for all table but only the max value for the row. You can create a single measure like maxvalue = max(table[column]) to check.
In that case you may use ALLSELECTED() or ALL() function like below.
In addition, It's better to share some sample data to us so that we can deal with the DAX for you.
Best Regards,
Jay
Hi @Anonymous ,
Measure works on visual level. In the first measure, you used filter(table), so the max() function wouldn't give you the max value for all table but only the max value for the row. You can create a single measure like maxvalue = max(table[column]) to check.
In that case you may use ALLSELECTED() or ALL() function like below.
In addition, It's better to share some sample data to us so that we can deal with the DAX for you.
Best Regards,
Jay
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |