Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am trying to display a card saying either "warning" or "all good" based on the count of coursekey.
I only want it to display warning if one specific coursekey appear more than once. However, the example above gave a warning message instead of all good even though these two coursekey were different. It should only give a warning if for example coursekey 36 appear twice.
Solved! Go to Solution.
Hi @Anonymous ,
Try this measure
Meaure 3 =
VAR a =
COUNT ( CheckforforgottenentriesLastyear[Course Key] )
RETURN
IF (
a >= 2,
"Warning",
"All Good"
)
Regards,
Harsh Nathani
Hi @Anonymous ,
Try this measure
Meaure 3 =
VAR a =
COUNT ( CheckforforgottenentriesLastyear[Course Key] )
RETURN
IF (
a >= 2,
"Warning",
"All Good"
)
Regards,
Harsh Nathani
Hi @harshnathani
It did work and show warning if there is more than 2 entries for from different coursekey
However, what I want is to only show if one coursekey occur twice but I think the DAX you gave me was pretty close to the one I want.
HI @Anonymous ,
Can you share sample data and expected output.
Regards,
HN
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |