Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Can we calculate the NPS score based on the value selected in the slicer? I haven't started working on creating a DAX formula for this but this is one of the requirements. There is a data hierarchy like Client name, Program name, Event name and session name. What I want is that when someone clicks on the client name they are given the NPS score for that client, similarly if someone clicks on the session, they are given the NPS score of that session etc. Is this possible in Power BI?
@Anonymous , Add all of them in a slicer and you should be able so value based on that
If needed use isfiltered or hasonevalue in the reverse order of hierarchy to display different value/measure
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
            | User | Count | 
|---|---|
| 8 | |
| 7 | |
| 6 | |
| 5 | |
| 4 | 
| User | Count | 
|---|---|
| 24 | |
| 11 | |
| 11 | |
| 9 | |
| 8 |