Forum Discussion
how many values per months
- Anonymous4 years ago
HI koorosh,
I think you need to use a date table that is not linked to current table records. Then you can use the current user's fields on row fields, data table field with year and month hierarchy on column fields.
After these steps, you can write two measure formulas to calculate the different calculations based on the current category group and use them on value fields.number of courses per month = CALCULATE ( COUNTA ( Table[courses] ), FILTER ( ALLSELECTED ( Table ), [course Date] IN VALUES ( Date[Date] ) ), VALUES ( Table[Users] ) ) number of login per month = CALCULATE ( COUNT ( Table[login Date] ), FILTER ( ALLSELECTED ( Table ), [login Date] IN VALUES ( Date[Date] ) ), VALUES ( Table[Users] ) )Regards,
Xiaoxin Sheng
HI koorosh,
I think you need to use a date table that is not linked to current table records. Then you can use the current user's fields on row fields, data table field with year and month hierarchy on column fields.
After these steps, you can write two measure formulas to calculate the different calculations based on the current category group and use them on value fields.
number of courses per month =
CALCULATE (
COUNTA ( Table[courses] ),
FILTER ( ALLSELECTED ( Table ), [course Date] IN VALUES ( Date[Date] ) ),
VALUES ( Table[Users] )
)
number of login per month =
CALCULATE (
COUNT ( Table[login Date] ),
FILTER ( ALLSELECTED ( Table ), [login Date] IN VALUES ( Date[Date] ) ),
VALUES ( Table[Users] )
)
Regards,
Xiaoxin Sheng