The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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/
User | Count |
---|---|
26 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
33 | |
13 | |
11 | |
9 | |
8 |