Error of Expression Refers to multiple columns. Multiple columns cannot be converted to scalar value

[Anonymous]

Can some one please comment on what is causing the error in the below DAX Power BI formula. I am trying to get the maximum/count of a numberic field which is sort of index calculated column based on 2 column grouping.

CALCULATE(COUNTROWS('Company Detail' ),FILTER(All('Company Detail'),Filter('Company Detail', Earlier('Company Detail'[Company_RecID])='Company Detail'[Company_RecID] )))

Count Manage Seats = CALCULATE(COUNT('Company Detail'[Company Date Order] ),FILTER(All('Company Detail'),Filter('Company Detail', Earlier('Company Detail'[Company_RecID])='Company Detail'[Company_RecID] )))

[Anonymous]

If you read https://dax.guide/filter/ carefully, you'll notice that the second argument to FILTER must be a boolean expression...

[Anonymous]

• Hi may I know if anyone have resolutions to this . Thanks in advance 

[Anonymous]

Thanks,

I tweaked the DAX formula a bit to the below, however the count is not evaluating as expected. If you see the below picture it shows as 19 but it should evaluate to 10 as per the first column readingAny clues what is wrong ? 

Count Manage Seats = CALCULATE(DISTINCTCOUNTNOBLANK('Company Detail'[Company Date Order] ),FILTER(All('Company Detail'),CountRows(Filter('Company Detail', Earlier('Company Detail'[Company_RecID])='Company Detail'[Company_RecID] ))))