HelloI’m fairly new to DAX and have a two part questionIn the following function Dates and Periods are tables. What do they actually bring / do in the function as the 2 filters at the end of Calculate?CALCULATE ( COUNTX ( 'Employees', IF ( ‘tblEmployees’[FTE] = "Yes" && ‘tblEmployees’[Curr_Emp] = "Yes",1)), USERELATIONSHIP (‘tblEmployees’[Start_Date], Dates[Date_Value] ), Dates, Periods) How do I run the function in DAX studio? I can use EVALUATE ‘tblEmployees’ to return the entire Employees table, but I can’t seem to figure how to test functions?Many thanks in advanceRoy

You need the row function as I explain at the bottom of this article. https://exceleratorbi.com.au/getting-started-dax-studio/

Anonymous

Not applicable

8 years ago

Solved

Dax and DAX studio question

Hello

I’m fairly new to DAX and have a two part question

In the following function Dates and Periods are tables. What do they actually bring / do in the function as the 2 filters at the end of Calculate?

CALCULATE (

COUNTX (

'Employees',

IF (

‘tblEmployees’[FTE] = "Yes" && ‘tblEmployees’[Curr_Emp] = "Yes",1)),

USERELATIONSHIP (‘tblEmployees’[Start_Date], Dates[Date_Value] ), Dates, Periods)

How do I run the function in DAX studio? I can use EVALUATE ‘tblEmployees’ to return the entire Employees table, but I can’t seem to figure how to test functions?

Many thanks in advance

Roy