Advertisement
Guest User

Untitled

a guest
Oct 22nd, 2014
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.26 KB | None | 0 0
  1. EVALUATE
  2. TOPN (
  3. 20,
  4. FILTER (
  5. CALCULATETABLE (
  6. SUMMARIZE (
  7. 'Customer',
  8. 'Customer'[Name],
  9. 'Customer'[CustomerId],
  10. "Sales per Sqft", 'Sales'[Sales per Sqft]
  11. ),
  12. DATESBETWEEN (
  13. 'Dates'[Date],
  14. DATE ( 2011, 4, 1 ),
  15. DATE ( 2012, 4, 30 )
  16. ),
  17. ( 'Property'[PropertyId] = 108
  18. || 'Property'[PropertyId] = 27
  19. || 'Property'[PropertyId] = 138
  20. || 'Property'[PropertyId] = 1
  21. || 'Property'[PropertyId] = 120
  22. || 'Property'[PropertyId] = 28
  23. || 'Property'[PropertyId] = 57
  24. || 'Property'[PropertyId] = 137
  25. || 'Property'[PropertyId] = 50
  26. || 'Property'[PropertyId] = 139
  27. || 'Property'[PropertyId] = 39
  28. || 'Property'[PropertyId] = 122
  29. || 'Property'[PropertyId] = 126
  30. || 'Property'[PropertyId] = 2 )
  31. ),
  32. NOT ISBLANK ( [Sales per Sqft] )
  33. ),
  34. [Sales per Sqft],
  35. 0,
  36. 'Property'[Property Name],
  37. 0
  38. )
  39. ORDER BY [Sales per Sqft] DESC, 'Customer'[Name] ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement