topic Re: Trying to display suspicious entries. in DAX Commands and Tips

Trying to display suspicious entries.

Anonymous — Wed, 17 Jun 2020 14:54:08 GMT

I am trying to make the visualization for trainning entries. The information are pretty strightforward here are the lists of available columns.

Table1
[Entry Date]
[Course Name]
[Percentage]

Eg.

[Entry Date] [Course Name] [Percentage]
01/01/2000 Database 50%
02/01/2000 Database 70%
03/01/2000 Database 30%

As can be seen above I wanna display like a warning message on some visuals on entries that the percentage decrease. Or in another case if someone submit an entry with 99% and forgot to submit another one with 100% for over two weeks that will also be a warning message.

Thank you everyone in advance

Re: Trying to display suspicious entries.

sturlaws — Thu, 25 Jun 2020 12:14:19 GMT

Hi Anonymous

try something like this:

alertFlag = VAR _course = CALCULATE ( SELECTEDVALUE ( entries[course] ) ) VAR _maxDate = CALCULATE ( MAX ( entries[Entry date] ), FILTER ( ALL ( entries ), entries[course] = _course ) ) VAR _maxDatePrevEntry = CALCULATE ( MAX ( entries[Entry date] ), FILTER ( ALL ( entries ), entries[course] = _course && entries[Entry date] < _maxDate ) ) VAR _difference = CALCULATE ( MAX ( entries[percentage] ), FILTER ( ALL ( entries ), entries[course] = _course && entries[Entry date] = _maxDate ) ) - CALCULATE ( MAX ( entries[percentage] ), FILTER ( ALL ( entries ), entries[course] = _course && entries[Entry date] = _maxDatePrevEntry ) ) RETURN SWITCH ( TRUE (), entries[course] = _course && entries[Entry date] = _maxDate && _difference < 0, "Alert", _maxDate - _maxDatePrevEntry > 14 && entries[Entry date] = _maxDate && _difference = 0, "Alert", BLANK () )

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

Re: Trying to display suspicious entries.

Anonymous — Fri, 26 Jun 2020 09:25:07 GMT

Hi sturlaws
It seems like on the switch it can only use measure and not a comlumn because the column name [Coursekey] inside table [Training] cann't be specified.

Re: Trying to display suspicious entries.

sturlaws — Fri, 26 Jun 2020 10:28:26 GMT

sorry, forgot to mention that this is the code for a calculated column