shown true or false by date filter

[Anonymous]

Hi, 

I have the table name total value

Timestamp	Value	Category
5/6/22	5	A
5/6/22	8	A
5/6/22	9	B
7/6/22	1	C
7/6/22	14	A

I using this dax for summaries table,

total value table =sum(total value[value])

Daily = SUMMARIZE(total value,total value[Timestamp],total value[Category],"Value",[Total value table])

yesorno = SWITCH(TRUE(),'Daily'[Category]="A"&&'Daily'[Value]>13,TRUE,'Daily'[Category]="A"&&'Daily'[Value]<=13,FALSE,BLANK())

In the result should 

Timestamp	Category	yesorno
5/6/22	A	False
5/6/22	B	Blank
7/6/22	C	Blank
7/6/22	A	True

How should I create the card if I have a date filter, I want to shown False for the day I selected (5/6/22)  and True for the day (7/6/22). 

I tried to input the yesorno into card but it shown the count of yesorno. 

Thanks for your help. 

[v-yadongf-msft · Accepted solution]

Hi @Anonymous 

Please try following DAX:

yesorno = SWITCH(
    TRUE(),
    'Daily'[Category] = "A" && 'Daily'[Value] > 13, "TRUE",
    'Daily'[Category]="A" && 'Daily'[Value] <=13, "FALSE")

Then you can get result you want.

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I would like to show the result of A only, and if A is true and false then always true. 

Thanks for your help.