Summary Tables of a larger data set

[Anonymous]

Hi Experts

how would you create a summary table of a larger data set which contains mulitple Business Unit Name and mulitple entries in the column B and C - which have fakes names in the attached file. i want to count ONLY rows where we have true in both columns "banana" and Apples" for each business unit.

[Stachu · Accepted solution]

assuming that you need a measure that counts rows meeting that criteria

Measure = CALCULATE(COUNTROWS('Table'),'Table'[Apple]=TRUE, 'Table'[Banana]=TRUE())

[Anonymous]

thanks Stachu....

under stand my error... much appreicated. for the feedback.