Divide by the total without regard to categories

[Syndicate_Admin]

Good

I need help with the following problem: The percentage of the column Uds/Veh. is Units between Veh_Turismo but I would like the denominator to always be Nº VEHICLES. What happens is that column Veh_Turismo is disaggregated according to the categories that I have put in the table but I want that not to happen, that the denominator is always constant with the value 9221 in this case that has been calculated as SUM(Veh_Turismo) being Veh_Turismo a column of 1 and 0 being 1 when

[Vehicle Type]="Tourism".

[Ritaf1983]

Hi @Syndicate_Admin 

Please share sample data (excluding sensitive information) in text format, along with your expected result and any relevant logic. For guidance, refer to

How to provide sample data in the Power BI Forum

If possible, upload a simplified .pbix file using this guide:

 How to upload PBI in Community

[Syndicate_Admin]

Units	Vehicles	Categories
23	1	a
65	1	b
45	1	c
21	0	c
52	0	b
35	1	b
64	0	a
20	1	a
23	0	b

Category	Current Percentage: SUM(Units)/SUM(Vehicles)	Expected Percentage: SUM(Units)/SUM(Vehicles)
a	45/2	45/5
b	100/2	100/5
c	45/1	45/5

In the real case, there are thousands of vehicles. They would be similar units but divided by, for example, 9221

[Ritaf1983 · Accepted solution]

Hi @Syndicate_Admin 
If I understood you correctly 
You can use these measures :

Units_ = CALCULATE(sum('Table'[Units]),'Table'[Vehicles]=1)

Vaechiles_ =

CALCULATE(sum('Table'[Vehicles]),all('Table'))

Percent = DIVIDE( [Units_],[Vaechiles_])

OR
1 combined measure like :

percent combined =

var units = CALCULATE(sum('Table'[Units]),'Table'[Vehicles]=1)

VAR vechicles = CALCULATE(sum('Table'[Vehicles]),all('Table'))

Return

DIVIDE(units,vechicles)

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.