Query on IF - Filter - and condition

VBABEGINER

Well-known Member
Joined
Jun 15, 2011
Messages
1,128
Hello board,

I've already dax formula with me. but now very confuse and dont understand how to question here.. hence wanted to go step by step solution..
below is my current dax -

VBA Code:
Issuance = 
Var a=
CALCULATE(COUNT('SRQ'[ID]),
FILTER('SRQ','SRQ'[Request Type - Prod]="Midterm"),
FILTER('SRQ','SRQ'[Total Cert]>=1))
+
CALCULATE(COUNT('SRQ'[ID]),
FILTER('SRQ','SRQ'[Request Type - Prod]="Renewal"),
FILTER('SRQ','SRQ'[Total Cert]>=1))


Var b=
CALCULATE(COUNT('SRQ'[ID]),
FILTER('SRQ','SRQ'[Request Type - Prod]="Midterm"))
+
CALCULATE(COUNT('SRQ'[ID]),
FILTER('SRQ','SRQ'[Request Type - Prod]="Renewal"))

return
a/b

now additional condition's are -
if my center = Mumbai then filter --
'SRQ'[Project Type]="Undelivered" AND 'SRQ'[Working Client Region]="Admin" & "Process Support"

if my center = Manila then filter --
'SRQ'[Project Type]="Undelivered" only

and should perform above calculation i.e. var a and b



Can any one please guide here...
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Watch MrExcel Video

Forum statistics

Threads
1,100,024
Messages
5,472,079
Members
406,800
Latest member
TeachMeExcelPlease

This Week's Hot Topics

Top