Forum Discussion
GroupBy and Having Clause
Hi, How do I use the GroupBy and Having clause in my dataset? I have the following table: [TableA] Name Completed TaskNumber Opp1 No 1 Opp1 No 2 O...
Thanks Matt but this didn't really do what I needed.
In the end I did a Group By via the Query Editor and did a slice visualisation against the count.
Cheers
MattAllington
Community Champion
Community ChampionPower BI doesn't work this way (I guess you know that). Are you trying to see these records in a visual, such as a table? If so, you need to write a measure that returns a non blank result when it passes your having test, and then place that in a visual along with the columns you want to see. A measure could be
display = if(countrows(tableA))>=3,countrows(tableA))
put name and the measure in a visual
Thanks Matt but this didn't really do what I needed.
In the end I did a Group By via the Query Editor and did a slice visualisation against the count.
Cheers