Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ?
Solved! Go to 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)
@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
@Mnassar4 Use CALCULATETABLE for that, this allows you to apply a filter from a related table or even use TREATAS.
@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)
User | Count |
---|---|
57 | |
21 | |
19 | |
16 | |
16 |
User | Count |
---|---|
87 | |
77 | |
52 | |
37 | |
21 |