Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

MTD based on condition

Hi Team, I have to calculate MTD as I have a table which has 4 columns as below, I have caluclate MTD based on the date. Requirment = Number of yes under each account and divded by nuumber of rows ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ,

    You could create a measure as follow:

    percent = 
DIVIDE (
    CALCULATE (
        COUNT ( [Account] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            [Account] = MAX ( 'Table'[Account] )
                && [Task Submision Status] = "Yes"
        )
    ),
    CALCULATE (
        COUNT ( [Account] ),
        FILTER ( ALLSELECTED ( 'Table' ), [Account] = MAX ( 'Table'[Account] ) )
    )
)

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    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
Not applicable
4 years ago

amitchandak ,

My requirment is to count number of yes divided by number of rows for each account under each vertical.

 

Thanks !

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

Anonymous , Unless you want Avg of Avg or Sum of Avg

This type of measure should help

 

Divide(countx(Filter(Table, Table[Task Submission Status]= "Yes") ,[account]), Count(Table[account]) )

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak ,

    This measure is not working.

    Giving an error.

     

     

    Thanks !

     

     

     

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      4 years ago

      Anonymous , the measure is still not complete. can share formula with me

       


      Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        amitchandak ,

        Here is the formula

         

        Thanks !