Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

meeting rate

Hi everyone, I'm a beginer in power bi. i need your support please. i want to calculate the percentage of a weekly meeting. (find below the table i'm using) i create this measure to make it "% At...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  Anonymous ,

     

    Here are the steps you can follow：

    1. Create measure.

    Measure =
var _eachweekta=
SUMX(FILTER(ALL('Table'),'Table'[Week]=MAX('Table'[Week])),[Taux de participation])
var _eachweekme=
COUNTX(FILTER(ALL('Table'),'Table'[Week]=MAX('Table'[Week])),[Members])
return
IF(
    MAX('Table'[Participation])="no meeting",BLANK(),
DIVIDE(
_eachweekta,_eachweekme))

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Liu Yang,
    Thanks a lot for your support.
    It works fine.

    Now i want to know if it's possible to create a measure that list only the weeks that lines don't contain "no meeting".

     

    Best regards,
    cenio

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi DataSlayer,

 

Thanks for your support.
Really appreciated.

One more question please.
it's possible to create a measure that list only the weeks that lines don't contain "no meeting"?

Best regards,
cenio

MAwwad's avatar
MAwwad
Icon for Solution Sage rankSolution Sage
3 years ago

You can use the COUNTX function in combination with a FILTER function to count the number of rows in your table that don't contain "no meeting" in the column of interest.

 

Weeks Without No Meeting = COUNTX(FILTER(Table, Table[Column of Interest] <> "no meeting"), Table[Week])