Forum Discussion

NithinBN's avatar
NithinBN
Icon for Helper II rankHelper II
3 years ago
Solved

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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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" ))

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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" ))