Two dropdown menus to select two columns and calculate the difference/correlation
Hi, I am looking to create two dropdown menus to select two arbitary persons from the data set and calculate the difference in each day or the correlation. The original dataset in in wide format. Mindful that it is not the ideal format in Power BI, I have unpivot it into a long format. Day Anne Bill Charles David Evan 1 1 2 2.5 3 3 2 2 3 2.5 2 1 3 3 4 2.5 1 2 However, I struggled to create a calculate the score difference between two person in each day. I tried to use do so by using NATURALJOIN and SELECTEDVALUE, but SELECTEDVALUE always return empty instead of what is selected in the dropdown menu. Please find below the link to my Power BI file https://limewire.com/d/997fa681-3d66-4657-a310-6a6901ef5466#iQGXUyBikm-_s5Ox-hS2APKQ5G5LUEo7NrGi5-r29kM Can you point me to the right direction please? Thanks a million.
How to make dropdown slicer present "multiple selections" if more than one value has been selected?
Hello everyone, In order to solve the problem I had in the 1st screenshot I applied the dax code shown in the 2nd screenshot. The code seems to be working perfectly fine as long as the user has chosen one specific deparment (single selection), the output is shown in screenshot 3. However in the case where a user picks a second deparment (screenshot 4), the measure will continue to show only one of the two or multiple selections. Is there a way to tweak the code (or a completely different code), that could instead show "Multiple selections" (Screenshot 5) when the user has chosen more than one departments? 1st 2nd 3rd 4th 5th Thank you in advance!
