Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
assuming that you need a measure that counts rows meeting that criteria
Measure = CALCULATE(COUNTROWS('Table'),'Table'[Apple]=TRUE, 'Table'[Banana]=TRUE())
assuming that you need a measure that counts rows meeting that criteria
Measure = CALCULATE(COUNTROWS('Table'),'Table'[Apple]=TRUE, 'Table'[Banana]=TRUE())
thanks Stachu....
under stand my error... much appreicated. for the feedback.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |