Forum Discussion
DAX Quarter
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 ...
Anonymous 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)
Greg_Deckler .. Thanks it workd with Calculatetable 🙂