Forum Discussion

mike_newbs's avatar
mike_newbs
Frequent Visitor
2 years ago
Solved

Create a line chart visuals that track %

Hello   Our business sends leads to business partners across the country who use them to sell products.   The leads have to be accepted by the partner. There are three different acceptance rates:...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi mike_newbs ,

    Please try this way:
    You can use this DAX to create a new measure:

    Accepted = 
    DIVIDE(
        CALCULATE(
            COUNTROWS('Table'),
            'Table'[Acceptance status] = "Accepted"
        ),
        CALCULATE(
            COUNTROWS('Table'),
            REMOVEFILTERS('Table'[Acceptance status])
        ),
        BLANK()
    )
    

    Sorry, the graphs don't look great created because the data was randomly created by me, but you should be able to use this DAX to achieve what you need. For Waiting to be accepted and Not accepted you just need to fine tune them in the DAX.

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