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.
Hi, I have the below sample dataset and i wish to flag those NPS between 0 to 6 as 1, but the below column doesn't work.
It considered 0 and BLANK as the same value.
Detractor Flag =
IF('Table'[NPS]=BLANK(),BLANK(),
IF('Table'[NPS]>=0 && 'Table'[NPS]<=6,1
,0))
Serial Number | NPS | Detractor Flag | Expected Output for Detractor Flag |
SN-111 | |||
SN-222 | 0 | 1 | |
SN-333 | 4 | 1 | 1 |
SN-444 | 0 | 1 | |
SN-555 | 5 | 1 | 1 |
Solved! Go to Solution.
Hi, @PBI_newuser
Please try the below.
instead of =blank() , try ==blank()
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Flag =
IF(
NOT ISBLANK( 'Table'[NPS] ),
IF( 'Table'[NPS] * ( 'Table'[NPS] - 6 ) <= 0, 1, 0 )
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi, @PBI_newuser
Please try the below.
instead of =blank() , try ==blank()
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |