I am trying to figure out the best way to get a count of the foreign key table rows as columns that I can use in questions/queries.
Here is an example, I have a Profiles table.
When I click on a given record the counts I want are displayed. Any help or pointers are appreciated thanks!
Thanks - But this does not exactly solve my problem. I loaded to example dataset for illustration and I think this should be possible using a Metric with a custom expression but I am getting this error.
I am using the documentation as my guide here but still unsuccessful. Thanks!
@Brandonlipman It’s not currently not possible to use Count as a function:
https://github.com/metabase/metabase/issues/11558 - upvote by clicking 
on the first post
As a workaround, since 0.35, you now have CountIf(...) among many other expressions, so you could try a little hack like:
CountIf([Orders.User_ID] > 0)
@Brandonlipman Which version of Metabase are you using? You need to select the column - I just wrote whatever you had.
