Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
3cdoug
Regular Visitor

Formula/Calculation help

CalcName = DIVIDE(CALCULATE(COUNTROWS('List1), 'List1'[Cert] = "Training1" && 'List1'[Section] == "HR"), DISTINCTCOUNT(Roster[ID])) * 100
 
I am using this formula to calculate the individual percentages of trainings complete within PowerBI. Is there anyway to write this as a general formula, and not have it for each individual training? As it currently stands I have 20 of these same calculations and I'm sure there is a way to write this formula one time and display it to my graph.
1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @3cdoug 

just place 'List'[Cert] in a table visual and place the same measure after deleting the relevant filter

CalcName =
DIVIDE (
CALCULATE ( COUNTROWS ( 'List1' ), 'List1'[Section] = "HR" ),
DISTINCTCOUNT ( Roster[ID] )
) * 100

View solution in original post

1 REPLY 1
tamerj1
Super User
Super User

Hi @3cdoug 

just place 'List'[Cert] in a table visual and place the same measure after deleting the relevant filter

CalcName =
DIVIDE (
CALCULATE ( COUNTROWS ( 'List1' ), 'List1'[Section] = "HR" ),
DISTINCTCOUNT ( Roster[ID] )
) * 100

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors