DAX, calculate percentages based on date or selected results
Hi I am struggling a little with what should be a simple percentage calculation. I am doing this with DAX, but I am using Excel PowerPivot so I hope you don't mind me posting this question here. I seem to be getting the calcualtion correct based on each row, but the comparison aganist the total when based selevct justa few members not working. My data is basically repeated every few days, and then I use a pivot/matrix to make a selction based on 'DateChecked' So when I select a date, the matric works out the percentages correctly, see column 'TotalComparison%' this is the entire list for 01/10/2022. However when I just focus say two people for example, the 'TotalComparison%' calculation is now based on currennt selection and not the orginal total mentioend above. Any help approciated, and sampe data posted here: DateChecked Name TotalNoTasks TotalFinished TotalToBeDone TotalNotFinished 01/10/2022 JOHN 12 3 0 9 01/10/2022 PAUL 15 0 0 15 01/10/2022 ARTHUR 24 3 15 6 01/10/2022 CHARLES 10 7 0 3 01/10/2022 SARA 9 3 0 6 01/10/2022 FIONA 27 12 3 12 15/10/2022 JOHN 18 3 0 15 15/10/2022 PAUL 18 12 3 3 15/10/2022 ARTHUR 15 6 6 3 15/10/2022 CHARLES 3 0 0 3 15/10/2022 SARA 3 0 3 0 15/10/2022 FIONA 3 0 3 0 01/11/2022 JOHN 6 3 3 0 01/11/2022 PAUL 3 0 3 0 01/11/2022 ARTHUR 36 13 14 9 01/11/2022 CHARLES 12 6 0 6 01/11/2022 SARA 9 3 3 3 01/11/2022 FIONA 3 3 0 0 17/11/2022 JOHN 3 0 0 3 17/11/2022 PAUL 18 1 14 3 17/11/2022 ARTHUR 12 0 9 3 17/11/2022 CHARLES 3 3 0 0 17/11/2022 SARA 39 15 3 21 17/11/2022 FIONA 3 0 0 3 Many thanks ChrisCNeed assistance with streaming dataset not working properly with visuals
Hi Team, I hope you can help me out with an issue that I've been trying to get help on for a while. Basically, I'm having issues with the visuals when using streaming dataset. The visuals doesn't show the correct numbers even when filtering it out. You guys may refer to the links below: 1. https://community.powerbi.com/t5/Issues/Issue-with-visuals-features-when-using-Streaming-Dataset/idc-p/1892926#M67156 2. https://community.powerbi.com/t5/Desktop/Filtering-date-by-latest-on-a-specific-filter-shows-blank/m-p/1869558#M719953 If you guys have any information about the issue that I'm encountering, please let me know. I would love to personally connect with you.
