Forum Discussion

ozgurozturk98's avatar
ozgurozturk98
Frequent Visitor
7 years ago

Counting rows

Hi all,   The table you see here consists of:   Date, ENDSOL, ENDIST, FA naantal, IST2 (Produced or not produced), and Column.   What I am trying to do is that at Column. The rows are added tog...
ozgurozturk98's avatar
ozgurozturk98
Frequent Visitor
7 years ago

I've found something like this on the forums:

 

Count of Active Employee =
VAR currentDate =
     MAX ( 'DateTable1'[Date] )
RETURN
    CALCULATE (
        COUNTROWS ( Master ),
        FILTER (
            ALL(Master),
               ( Master[Start Date] <= currentDate
                         && Master[End Date] >= currentDate )

 

But it seems like it is not working. 

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi ozgurozturk98,

 

Besed your description, if I understand your sceanrio correctly that the first five columns are the original data and the last column is what you want?

 

If it is, I'm still a little confused about your scenario, it seems that the colmn is calculated based on the FA-aantal, but what is the logic condition? 

 

Could you describe your scenario in more details?

 

Best  Regards,

Cherry