topic Re: Card and if statement in DAX Commands and Tips

Card and if statement

Anonymous — Thu, 02 Jul 2020 12:46:03 GMT

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.

Re: Card and if statement

Anonymous — Thu, 02 Jul 2020 14:02:55 GMT

Hi Anonymous ,

Try this measure

Meaure 3 = VAR a = COUNT ( CheckforforgottenentriesLastyear[Course Key] ) RETURN IF ( a >= 2, "Warning", "All Good" )

Regards,

Harsh Nathani

Re: Card and if statement

Anonymous — Thu, 02 Jul 2020 16:13:41 GMT

Hi Anonymous
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.

Re: Card and if statement

Anonymous — Fri, 03 Jul 2020 07:04:35 GMT

HI Anonymous ,

Can you share sample data and expected output.

Regards,

Re: Card and if statement

Anonymous — Fri, 03 Jul 2020 07:15:49 GMT

Hi Anonymous

I modified my query during the ETL process and it worked.

Thank you 🙂