Forum Discussion
Relation between columns\tables
Hello All,
I have a table which consists of Collage,Department,Student, ActiveStudent.
This is how it looks like.
I want to calculate:
I want to calculate:
1)No of Col:
2)No of Col having Department:
3)No of Col having Department and having student:
4)No of Col having Department and having student AND active student:
and I want to visulaze like this:
I want to do calculation on Collage, so that on drill down of these bars I could see to which collage it has considered for calculation.
Thank you in advance!
NithinBN ,
Total rows = countrows(Table)
Total Collages = distinctcount(Table[Collage])
Total Collages having dept and student = calculate(distinctcount(Table[Collage]), filter(Table, not(isblank(Table[Department])) && not(isblank(Table[Student])) ) )
Total Collages having dept and student = calculate(distinctcount(Table[Collage]), filter(Table, not(isblank(Table[Department])) && not(isblank(Table[Student])) && [Active Student] = "Yes" ))
1 Reply
NithinBN ,
Total rows = countrows(Table)
Total Collages = distinctcount(Table[Collage])
Total Collages having dept and student = calculate(distinctcount(Table[Collage]), filter(Table, not(isblank(Table[Department])) && not(isblank(Table[Student])) ) )
Total Collages having dept and student = calculate(distinctcount(Table[Collage]), filter(Table, not(isblank(Table[Department])) && not(isblank(Table[Student])) && [Active Student] = "Yes" ))