Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have created a measure which I thought calculated the max from a caculated column however when I have written the measure and added it into a matrix or table under values I have the option to change the value to sum, average, min, max etc. Once I have changed it to max, by results appear correct though.
I need to sum the values in two of the column (My MAX - only when the value is set to MAX though) and sum it with Emp ID in the table visual but it doesn't return the expected results.
My max meaure is:
The two columns (results and if over 10 are what I am trying to acheive).
Solved! Go to Solution.
@pardeepd84
"My Max" is a calculated column and you have set the calculation to MAX . If you can share a sample file then it would be great.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@pardeepd84
"My Max" is a calculated column and you have set the calculation to MAX . If you can share a sample file then it would be great.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @ Fowmy,
unfortunately due to data protection I am unable to share the data.
I have created a measure to get the max based on a calculated and then used the ALL EXCEPT filter however although I have used the MAX function when I add it to a table visual it doesn't show the max, instead I have the option to get the average, min,max,standard deviation etc. Once I select MAX though and it gives me the results I require. From this calculation I now need to sum the rows for 2 columns when the values for "My Max" has been set to MAX.
I have managed to resolve this myself, no further assistance required for this query.
@pardeepd84
Gald you managed to solve it. Happy to assist you in any future issues/questions.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |