Forum Discussion

Milozebre's avatar
Milozebre
Icon for Helper V rankHelper V
8 years ago
Solved

measure with total by values

Hello dear community,    I call on you because I block. I looked several links here (distinct count group by, ...) and I do not find the good result. I am a little hopeless. I do not see where I'm...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI Milozebre,

     

    You can use below formula to get total value based on horaires and distinct email count:

    Total =
DISTINCTCOUNT ( Table2[Email] ) * SELECTEDVALUE ( Table2[Horaires] )


    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Milozebre,

 

You can use below formula to get total value based on horaires and distinct email count:

Total =
DISTINCTCOUNT ( Table2[Email] ) * SELECTEDVALUE ( Table2[Horaires] )


Regards,
Xiaoxin Sheng

Milozebre's avatar
Milozebre
Icon for Helper V rankHelper V
8 years ago

Anonymous

 

Hello Thank you for answer. its working

Is it possible to get the total ? 

 

I'm sorry if I bother you. But I have to provide this information. I didn't create these tables and I started with DAX. The ultimate goal is to have the total hours worked and to have the theoretically worked total time and then make the rate.

 

Many thanks in advance

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI Milozebre,

     

    Please share a pibx file with sample data and expected result for test and coding formula:

     

    Regards,

    Xiaoxin Sheng