Forum Discussion
DAX Combining IF with SELECTEDVALUE Showing Incorrect Result
ahiemstra If the 43 days is the right number and you want to have one measure to allow the user to choose the activity type, my solution is this:
In the Sample Report 3 if you put this New Avg Measure instead of your Avg Time/Day you will have this result:
Kyla = 1.22
And if you choose other Activity Type on the slicer you will have the respective chart.
I hope this is what are you looking for, if you need any help please let me know.
ahiemstra If the 43 days is the right number and you want to have one measure to allow the user to choose the activity type, my solution is this:
In the Sample Report 3 if you put this New Avg Measure instead of your Avg Time/Day you will have this result:
Kyla = 1.22
And if you choose other Activity Type on the slicer you will have the respective chart.
I hope this is what are you looking for, if you need any help please let me know.
