Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create column charts month wise

Hi team, I've data in the following format in a table titled "sms": datetime reason status 30-01-2022 AA failed 12-02-2022 AA failed 15-02-2022 AB failed   Then i've create...
Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    Hi Anonymous ,

     

    Add the following measure to your model and use it on your chart:

     

    Percentage by month =
DIVIDE (
    COUNTROWS ( sms ),
    COUNTROWS (
        FILTER ( ALL ( SMS ), sms[datetime] IN VALUES ( 'Calendar'[Date] ) )
    )
)

     

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

Hi Anonymous ,

 

Add the following measure to your model and use it on your chart:

 

Percentage by month =
DIVIDE (
    COUNTROWS ( sms ),
    COUNTROWS (
        FILTER ( ALL ( SMS ), sms[datetime] IN VALUES ( 'Calendar'[Date] ) )
    )
)