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 m having a table with below values, I need a count the equip id row 's using filter Return_status ='NO' & REMARK1='DELIVERY' & result value need - with consent value 100
Please can u help
EQUIP_ID | EQUIP_TYPE | RETURN_STATUS | REMARK1 |
L 10573 | Van | NO | DELIVERY |
m 67692 | Van | NO | DELIVERY |
k 77921 | Van | NO | DELIVERY |
l 90507 | Van | YES | DELIVERY |
f 88162 | Truck | NO | LOADING |
k 69179 | Van | NO | DELIVERY |
d 22581 | Truck | YES | LOADING |
p 21886 | Van | NO | DELIVERY |
Solved! Go to Solution.
You were sooo close. All you need to do is make use of the OR function. So the code would read:
Available = CALCULATE( COUNTA(EquipLive[EQUIP_ID]), OR( 'EquipLive'[REMARK1]="DELIVERY", 'EquipLive'[REMARK1]="LOADING" ), 'EquipLive'[RETURN_STATUS]="NO" )
Here is what i'd write. This is off the top of my head so you might need to put it into your Power BI and get it to check for errors:
Equip Count = Calculate( counta('TableName'[EQUIP_ID}), 'TableName'[RETURN_STATUS] = "NO", 'TableName'[REMARK1] = "DELIVERY" )
Where 'TableName' is the name of the table that you are using
EDIT: I should note this is intended as a measure.
Hi Ross,
Thanks for replying , its working
if i want include "LOADING " as well, I tried
Available = CALCULATE(COUNTA(EquipLive[EQUIP_ID]),'EquipLive'[REMARK1]="DELIVERY",'EquipLive'[REMARK1]="LOADING", 'EquipLive'[RETURN_STATUS]="NO")
Giving no result , Please help
You were sooo close. All you need to do is make use of the OR function. So the code would read:
Available = CALCULATE( COUNTA(EquipLive[EQUIP_ID]), OR( 'EquipLive'[REMARK1]="DELIVERY", 'EquipLive'[REMARK1]="LOADING" ), 'EquipLive'[RETURN_STATUS]="NO" )
Thanks Ross for help.
OR fucntion can create max 2 arguments , if i want add one more is there any option
You are able to nest OR within OR. If you remember doing Algrabra at school, it works like that where you resolve the innerparts of the equation and work outwards. So lets say you had 8 things to OR, you could have a statement like:
OR(OR(OR(OR(OR(OR(OR(1,2),3),4),5),6),7),8)
it would resolve like:
Does 7 = OR(OR(OR(OR(OR(OR(OR(1,2),3),4),5),6),7),8)
OR(OR(OR(OR(OR(OR(FALSE,3),4),5),6),7),8)
OR(OR(OR(OR(OR(FALSE,4),5),6),7),8)
OR(OR(OR(OR(FALSE,5),6),7),8)
OR(OR(OR(FALSE,6),7),8)
OR(OR(FALSE),7),8)
OR(TRUE,8)
TRUE
Thanks Ross, Go it
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |