Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
62 |