Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
In my dashboard I have some tables with filters applied to them. What I want to do is count the number of rows in those tables, and represent those values as a variable. How do I do this?
Example:
What the table shows is ID's where the count has value 10 or higher, this is done by applying filters to the table. In the example below I want the variable to be '2', as there are two rows where an ID has count 10 or higher. This variable is functioning as a trigger, so I need it implemented in a Card/Gauge/KPI graphic.
ID | Count |
4919 | 12 |
3919 | 10 |
How do I extract the number of rows, from a table graphic with filters applied to it?
Kind regards,
Bart
Solved! Go to Solution.
I continued my question in a new forum where I found a solution in creating new DAX tables:
Solved: Measure combining filter and group by (or similar ... - Microsoft Power BI Community
Am I right to conclude that it is not possible to extract the information from a filtered table visual?
I am now struggling with measures to combine filters with 'group by' or 'summarize(columns)', getting closer to the same results the visual table has. I will post the final solution here FYI.
I continued my question in a new forum where I found a solution in creating new DAX tables:
Solved: Measure combining filter and group by (or similar ... - Microsoft Power BI Community
Hi @BartvDonkelaar,
You can use:
Count = CALCULATE(COUNT('Table'[ID]),FILTER('Table','Table'[Count]>=10))
Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Previous Forecasts
Hi @Shaurya ,
Thank you for your reply!
I am familiar with the COUNT function. What I do not understand however is what table to reference ('Table' in your example). The table shown in my question is not defined in my data model, and only exists on my dashboard as a visual. This visual has filters applied to it, and results in the example table I showed in my question. From that table visual I would like to count the rows.
So basically my question is; can you refer to a table visual on your dashboard, and if so, how?
Kind regards,
Bart
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |