Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have a column: SCORE with values 1, 2, ..., 10.
Then I have 3 measures:
Solved! Go to Solution.
The score column is the one that has values that create the measure.
So the column date is in relationship with Date Table, no problem with Quarters, months etc.
But the problem is when I put in the table visual along with for example Company column.
I tried your solution, but the values get too low
Hi @Sab ,
Would you like to provide some sample data? The information you give is limited, I can't get the context of the table.
And you can try this measure:
NPS = ( [Promoters] - [Detractors] ) / CALCULATE ( COUNTROWS ( 'Responses Database' ), ALLEXCEPT ( 'Responses Database', 'Responses Database'[Campany], 'Responses Database'[Quarter] ) ) * 100
The score column is the one that has values that create the measure.
So the column date is in relationship with Date Table, no problem with Quarters, months etc.
But the problem is when I put in the table visual along with for example Company column.
I tried your solution, but the values get too low
There was no problem in measures, just the dummy data created that illusion...
Thanks all who took time to look at this.
Keep in mind tables will apply a "filter" context to your measure unless you explicitly tell it not to with a function like ALL().
Can you please be more specific?
thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |