I am just using the set to have the coun
I am just using the set to have the count. If the set was put on the rows, then you would have seen the result as you told, just those greater than 4000. Hope you got the point.
Top Tags
Latest Posts
- Dynamic format strings with calculation groups
- Set functions in DAX: UNION, INTERSECT, and EXCEPT
- Announcing improved MDX query performance in Power BI
- Using Many to Many for Running Sum
- Creating a simpler and chart-friendly Date table in Power BI
- Introduction to DAX Financial Functions – Part 1
- Understanding the difference between LASTDATE and MAX in DAX
- Dealing with Blanks Ragged Hierarchies in PowerBI (ISINSCOPE)
- Using calculation groups to selectively replace measures in DAX expressions
- Default calculation item in calculation groups
Most Read
- How to install Adventure Works SQL DW and Analysis Services 2005/2008 sample database and project
- Microsoft SQL Server Analysis Services (SSAS) Books
- MDX-How can I get Last (Previous) Year to Date (YTD) values?
- Time MDX Cheat Sheets
- Newsletter And RSS
- Analysis Services 2000 and 2005 Connection string properties
- How to fix Analysis Services deployment error No mapping between account names and security IDs was done
- Script to automate SSAS partition management (SQL + SSIS)