Distinct Count of rows grouped by measure

[rmeng]

Hello Guys,

I need a formula for the Count of [HCO] for 3 different tables: HCO, HCO+SECTION and HCO+SECTION+Attribute.

• HCO table should only count 3 HCO's.
• HCO+SECTION counts 5 HCO's (combines the distint count of [HCO] and [SECTION]
• HCO+SECTION+ATTRIBUTE (combines all rows)

[jameszhang0805 · Accepted solution]

Options =

SELECTCOLUMNS(

{ ( 1 , "HCO") ,

( 2 , "HCO+SECTION" ) ,

( 3 , "HCO+SECTION+ATTRIBUTE" )

} ,

"Index" , [Value1] , "Options" , [Value2] )

[rfigtree]

maybe

mCountHCO:=COUNTROWS(SUMMARIZE(Table1,Table1[HCO]))
mCountHCOandSection:=COUNTROWS(SUMMARIZE(Table1,Table1[HCO],Table1[SECTION]))
mCountHCO&Section&Attribute:=COUNTROWS(SUMMARIZE(Table1,Table1[HCO],Table1[SECTION],Table1[ATTRIBUTE]))

[rmeng]

Thanks but don´t forget about the average score.

[rfigtree]

"thanks"!

re read your question.

I need a formula for the Count of 

[rmeng]

Sorry, you´re right I  didn´t explain in the best way. So let me rephrase  I need a formula for the count of the HCO like the tables I´ve shown. So the [readiness score] is a part of that tables.

So in the first table, for HCO ="A" I have 8 rows and I need the average of the 8 rows and the count shoulb be = 1 ( Distinct count of HCO="A").