Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hey,
Despite looking at other threads i'm still struggling to pull a query together that will add two existing meassures together then divide by a total ID column.
So I have these two separate meassures for each of the below already that work, I need to add those together (Which is simple with the = Meassure1 + Meassure 2) but where I get stuck is then dividing those two combined total meassures to divide by a CountA(<Table>[<Column]
Corp_Vehicles = CALCULATE(COUNTA
(<Table Name>[<Column>]),
(<Table Name>[Column] IN
{
("<Username>")
}
&&
(<Table Name>[<Column>]] IN
{
("<sales stage column>")
}
)))
TU_Vehicles = CALCULATE(COUNTA
(<Table Name>[<Column>]),
(<Table Name>[<Column>] IN
{
("<Username>")
}
&&
(<Table Name>[<Column>] IN
{
("Sales Stage Column")
}
)))
Any advice would be appreciated
Hi Support,
Since no-one else in the community responded, I managed to figure it out, please close.
Thankyou
Andy
Hi @andyfoster ,
In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_Binbin Yu
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 39 | |
| 37 | |
| 29 | |
| 24 |
| User | Count |
|---|---|
| 119 | |
| 100 | |
| 72 | |
| 69 | |
| 65 |