cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper I

## Calculate Percentage

I want to calculate the percentage of "Y" (Say in Col 3) mentioned for seperate divisions (Say )1,2,3 (in col 1). Please suggest.
My requirement is to get the %age of no. of "Y", by an individual division, out of the total transaction each does.

Need to check, what percentage of each division is a Y, and then Percentage of Y in total out of the total description

 Division Descrption (Say Anythin) If Nomenclature Rule Followed in Description A asdasd Y B sdfsdfds N C fgjfgh N A erwer Y B werwer Y C fjhfgj N
1 ACCEPTED SOLUTION
Resolver I

Try these series of measures.

CountY =: Countrows (

Filter ( Table,

Table1[Column Yes or No] = "Y")

)

CountTransactions =: Countrows ( Table )

%Y =: Divide ( [CountY], [CountTransactions])

2 REPLIES 2
Resolver I

Try these series of measures.

CountY =: Countrows (

Filter ( Table,

Table1[Column Yes or No] = "Y")

)

CountTransactions =: Countrows ( Table )

%Y =: Divide ( [CountY], [CountTransactions])

Helper I

Thanks Gabriel.

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors