Forum Discussion

Cromero3000's avatar
Cromero3000
Icon for Helper I rankHelper I
6 years ago
Solved

How to measure attendance

Hello team!, I'm no expert with DAX or doing measures and I'm starting to build a dashboard for attendance. Let me give you an example of what I need: * There are 5 modules * Each module has diffe...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Cromero3000 

    As tested, the "Assistance" table and "Disciples" table should modify their relatiosnhip as below:

     

    Then you could create a measure

    Discount =
CALCULATE (
    DISTINCTCOUNT ( Assistance[Discipulo] ),
    FILTER (
        ALLSELECTED ( Assistance ),
        Assistance[Tema] = MAX ( Assistance[Tema] )
    )
)

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Cromero3000 

1.

because at the beginning, you create a relationship for table "Assistance" and "Disciples" based on 

"Assistance"[Codigo Discipulo] and "Disciples"[Code],

But you can see from the following picture, "Assistance"[Codigo Discipulo] and "Disciples"[Code] are not consisent, 

when modifying the relationship to "Assistance"[Discipulo] and "Disciples"[Disciples], it works.

"Assistance"[Discipulo] and "Disciples"[Disciples] are consisent.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Cromero3000's avatar
    Cromero3000
    Icon for Helper I rankHelper I
    6 years ago

    Thank you v-juanli-msft  !, I didn't realize the codes were not the same, I'll proceed and fix that. Thanks again for your help with this!