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.
I am fairly new to powerBi and a first time poster, so sorry for any incompleteness in my posting. I am analyzing survey results. I have one column that returns a list of all the departments they have worked with to at our company. I then added a slicer to find if that broke out the deparments and searched in the department column to update the results:
Here is that measure:
IsFiltered =
IF(
SUMX('Slicer',
FIND(
'Slicer'[Departments],
MAX('Why Havent you enrolled'[Departments]),,0)) > 0,
"True",
"False"
)
Then I filter on the Chart to show Is Filtered = 'True'
But when the chart updates it does not bring in the correct count for anything, it updates the column values perfectly, but it is still retaining the count prior to the slicer.
The photos below are the original without clicking on a deparment. For this example I click on coolsculpting as the department, (they should only have one reason, "I am healthy and do not need a portal" as reference in image 3). It is returning the reason correctly, but it is still has the number as 4 when it should be 1. What Am I missing.
Solved! Go to Solution.
Yuliana. Thanks for Responding. I end up figuring it out. What I ended up having to do was doing a sum with a filter and put that value in my display rather than a straight count:
Enrolled Department Count = CALCULATE(sum('Why Havent you enrolled'[Count]),(FILTER('Why Havent you enrolled','Why Havent you enrolled'[IsFiltered] = "True"))).
And then I removed the aformentioned IsFiltered from my filters.
After I made those two changes it all worked for me.
Hi @dkk427,
Could you please share some sample data and provide more details about how to reproduce your scenario? In above post, you said "It is returning the reason correctly, but it is still has the number as 4 when it should be 1", how did you calculate the count value?
Regards,
Yuliana Gu
Yuliana. Thanks for Responding. I end up figuring it out. What I ended up having to do was doing a sum with a filter and put that value in my display rather than a straight count:
Enrolled Department Count = CALCULATE(sum('Why Havent you enrolled'[Count]),(FILTER('Why Havent you enrolled','Why Havent you enrolled'[IsFiltered] = "True"))).
And then I removed the aformentioned IsFiltered from my filters.
After I made those two changes it all worked for me.
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |