Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Summary Tables of a larger data set

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.

 

Capture.PNG

1 ACCEPTED SOLUTION
Stachu
Community Champion
Community Champion

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

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


Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

View solution in original post

2 REPLIES 2
Stachu
Community Champion
Community Champion

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

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


Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Anonymous
Not applicable

thanks Stachu....

 

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.