DAX Quarter

[Mnassar4]

Hi Guys ,

I have a data per empolyee each quarter with total number of contribution column .. I wan to create a column to check wether the total number of contirbution is > 11 for each empolyee per Quarter.. can you please help on that  ?

[Mnassar4]

@Greg_Deckler .. Thanks it workd with Calculatetable 🙂 

[Mnassar4]

@Greg_Deckler sorry for my late reply , but what if Quarter & Empolyee is in 2 different data tables and tables are connected by relationship already .. 

 VAR __Table = FILTER(ALL('Table'),[Employee]=__Employee && [Quarter]=__Quarter

 in the above line it is assuming that 'Table' is the same , that's how Filter Function works , but actually Quarter & Empolyee Columns are in different tables .. so How can we adapt the measure then ? .. Thanks in Advance 

[Greg_Deckler]

@Mnassar4 Use CALCULATETABLE for that, this allows you to apply a filter from a related table or even use TREATAS.

[Greg_Deckler · Accepted solution]

@Mnassar4 Hard to be specific without sample data but probably something like:

Measure =
  VAR __Employee = MAX('Table'[Employee])
  VAR __Quarter = MAX('Table'[Quarter])
  VAR __Table = FILTER(ALL('Table'),[Employee]=__Employee && [Quarter]=__Quarter)
RETURN
  IF(COUNTROWS(__Table)>11,1,0)