Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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/