Hi all,
I wish to sum together a COUNTROWS function and then divide it by the total number of rows.
Total % := DIVIDE(CALCULATE(COUNTROWS(Chron),Chron[Chron Band] = "Less than 90 days", Chron[Chron Band] = "No Chron and less than 60 days"), (COUNTROWS(Chron), 0 )
The data is under Chron Band column, I wish to count "Less than 90 days" + the count for "No Chron and less than 60 days" then to finally divide it by the total number of rows.
Bookmarks