Create table visual that shows First AND Final warnings

[Auski]

Good afternoon all,

I think this one will be solved pretty quickly, but could use the help of my betters!

I have a table called 'performance_management' that contains the following sample data.

ID	Warning	Grade
10088	First Warning	1
10092	First Warning	1
10142	First Warning	1
10625	First Warning	15
10775	First Warning	14
11101	First Warning	11
12777	First Warning	16
12777	Final Warning	14
12832	First Warning	14
21621	First Warning	1
21600	First Warning	11
22116	First Warning	10
22116	Final Warning	17

I would like to create a table visual in my dashboard that shows only those ID's that have had their first AND final warnings only. In this example I would expect that outcome to be the following:

ID	Warning	Grade
12777	First Warning	16
12777	Final Warning	14
22116	First Warning	10
22116	Final Warning	17

Hope this makes sense.
Thanks so much 🙂

[amitchandak]

@Auski ,

Create measures like

M1 = calculate(distinctcount(Table[Warning]) , filter(all(Table), Table[ID] = max(Table[ID])  && Table[Warning] in {"First","Final"} ) )

M2 =

if(Not(Isblank([M1])) , Sum(Table[Grade]), Blank())

[Auski]

Thank you @amitchandak , that worked perfectly 🙂

[amitchandak · Accepted solution]

@Auski ,

Create measures like

M1 = calculate(distinctcount(Table[Warning]) , filter(all(Table), Table[ID] = max(Table[ID])  && Table[Warning] in {"First","Final"} ) )

M2 =

if(Not(Isblank([M1])) , Sum(Table[Grade]), Blank())