Forum Discussion

Dougers1's avatar
Dougers1
Frequent Visitor
2 years ago
Solved

need help with this dax

Hi

 

i have this measure that brings back the total  count of BSL requests 

 

BSL Total Requests = CALCULATE(COUNTROWS('Export') ,'Export'[Request Grade] = "BSL")
 
i need to also see many i have filled - the filled column is named status. what do i need to add so it checks the grade is BSl  and then staus is filled
Dax Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    Dougers1 

    Try this measure:

    	CALCULATE(
		COUNTROWS('Export') ,
		'Export'[Request Grade] = "BSL",
		'Export'[status] = "filled"
	)

1 Reply

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    2 years ago

    Dougers1 

    Try this measure:

    	CALCULATE(
		COUNTROWS('Export') ,
		'Export'[Request Grade] = "BSL",
		'Export'[status] = "filled"
	)