Forum Discussion
Create a line chart visuals that track %
- Anonymous2 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.
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.
Hello Anonymous
Thank you very much for your help, thats perfect.
Kind regards
Michael