Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have created a pivot table for NPS using DAX.
There is positive, negative and neutral scores.
When I want to see details of only negative scores by clicking on negative value which is 1 but it shows the total 9 raws.
This happens woth all cases ( positve, neutral and negative).
Can someone please help.
Positive | Negative | Neutral | Total | NPS |
5 | 1 | 3 | 9 | 44.44 |
Not sure I 100% get what you are saying. Turn off totals in the visual? What visual are you using? Is that source data or example output?
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
These negative, positive seem like measure, not dimension member that used to pivot.
The measure drill will not filter the value.
Hello,
Amit , you are right that these are measures. Is there any work around to drill down the data as I want?
Can you share sample data and sample output.
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |