Formula/Calculation help

3cdoug — Fri, 09 Jun 2023 16:22:18 GMT

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.

Re: Formula/Calculation help

tamerj1 — Fri, 09 Jun 2023 16:40:39 GMT

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

topic Re: Formula/Calculation help in DAX Commands and Tips

Formula/Calculation help

Re: Formula/Calculation help