Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Reposting this with clearer table
So I have a table like so:
Region | Name | Flag | Count of Job ID |
North | John | On | 12 |
South | Drake | Off | 11 |
South | Jason | On | 5 |
West | Kendall | Off | 9 |
South | Jenny | Off | 13 |
East | Sam | On | 8 |
The last column is a count of Job ID, which is a text type column. As an example, there are 12 Job ID entries with region North, name John, and flag On. I want a card that shows the number of entries that are "Off" and have a count higher than 10.
The preferred outcome would be a card displaying 2 since there are two rows that fit those criteria. How would I go about doing that?
Solved! Go to Solution.
And voila:
See attached .pbix file
So the data coming in (from direct query) looks like this:
Region | Name | Flag | Job ID |
North | John | On | 16127 |
North | John | On | 77647 |
North | John | On | 41588 |
North | John | On | 46424 |
North | John | On | 24132 |
North | John | On | 56180 |
North | John | On | 57396 |
North | John | On | 41324 |
North | John | On | 8899 |
North | John | On | 809 |
North | John | On | 19558 |
North | John | On | 91024 |
North | John | On | 90642 |
South | Drake | Off | 52577 |
South | Drake | Off | 76784 |
South | Drake | Off | 81416 |
South | Drake | Off | 77264 |
South | Drake | Off | 53032 |
South | Drake | Off | 25992 |
South | Drake | Off | 50560 |
South | Drake | Off | 20368 |
South | Drake | Off | 81093 |
South | Drake | Off | 97126 |
South | Drake | Off | 46680 |
South | Drake | Off | 59402 |
South | Jason | On | 93735 |
South | Jason | On | 24804 |
South | Jason | On | 8312 |
South | Jason | On | 96618 |
South | Jason | On | 5066 |
...etc
And the table created above has the column "Count of Job ID" through Power BI. "Count of Job ID" is not an actual column, it's more like a measure. It's an aggregate count of "Job ID". So I can't use the function you've provided since "Count of Job ID" is not a column in my table.
That totally worked! Thank you so much!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
111 | |
59 | |
57 |