Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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:
I created a graph in Excel that tracks the Acceptance Rates, split by product and month.
The data I use is basically:
Lead created | Product | Acceptance status |
Apr | Product 1 | Accepted |
Apr | Product 1 | Accepted |
May | Product 1 | Waiting to be accepted |
May | Product 2 | Not accepted |
Jun | Product 3 | Not accepted |
The graph in Excel shows the % of leads (split by month and product) accepted. Most cases this is over 90%
How can I do this in Power Bi?
Also is it possible to avoid using the "Group by" function? Each lead has its own ID that is linked to other visuals. Ideally I would like to keep the ID because if a user filters by product on a sliver in the report, it updates all other visuals and it would be great to have the line chart update as well.
Kind regards
Michael
Solved! Go to Solution.
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |