Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi @Kim_Sky
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.
Hi @Kim_Sky
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.
I would like to show the result of A only, and if A is true and false then always true.
Thanks for your help.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |