Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I have a visual which shows the top 5 reasons of why customers churn.
The value of each reason's share is calculated like so
Then, when I use a page filter (by slicer) for week selection
This is what happens
When I use a page filter that for example filters for months, it works all fine, it shows the visual as it should, showing for all the weeks within these months. Only with this week filter I get a flat line for each reason and they all have a share of 100%. (It only happens within this visual, any tables that show the same metric work perfectly fine.)
I am lost - any help is appreciated.
Best,
Janine
Solved! Go to Solution.
HI @MFelix thanks for your answer, with a little help from your answer and some more PowerBI DAX researching (and blunt trying out) I managed to solve the issue by changing the DAX from
ALL((table[Reason])
to
HI @MFelix thanks for your answer, with a little help from your answer and some more PowerBI DAX researching (and blunt trying out) I managed to solve the issue by changing the DAX from
ALL((table[Reason])
to
Hi @janinw ,
You are making the ranking using the ALL statement, further more you do it based on a column that is the column Reason that way the calculation will only be correct when you have all the values in your table select so when you start to make filters based on other columns the table/column/row context changes and your result always returns 1.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
90 | |
67 | |
62 | |
53 |