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.
Count of the number of Regions that have shown up 6+ times in any 30 day period.
That is...
If Denmark is the only region that has shown up 6+ times the answer would be 1.
If Denmark and UK have show up 6+ times the answer would be 2.
I am stumped as to where to start on this one....
Solved! Go to Solution.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, use a VAR to create a table of all of the relevant records. Use SUMMARIZE or GROUPBY to summarize that table variable to a new table variable. Use ADDCOLUMNS on this to add a COUNT or COUNTROWS. Then, use COUNTX on a FILTER of this last table variable with a filter of >=6 of your count.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, use a VAR to create a table of all of the relevant records. Use SUMMARIZE or GROUPBY to summarize that table variable to a new table variable. Use ADDCOLUMNS on this to add a COUNT or COUNTROWS. Then, use COUNTX on a FILTER of this last table variable with a filter of >=6 of your count.
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 |
---|---|
103 | |
101 | |
87 | |
73 | |
67 |
User | Count |
---|---|
119 | |
111 | |
95 | |
79 | |
72 |