Forum Discussion

AlexaderMilland's avatar
AlexaderMilland
Icon for Helper III rankHelper III
2 years ago

Measures as a dimension?

So I don't know why I can't get the grasp on how to do this. For a simple version i have an "Orders" table with just 3 columns   OrderID | CustomerID | Date    I want a matrix visual that shows ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

AlexaderMilland Create a separate, disconnected table to store your order numbers in a single column

1

2

3

4

5

 

Put that in a table visual along with this measure:

Measure =
  VAR __Count = MAX('Disconnected Table'[Orders])
  VAR __Table = SUMMARIZE( 'Orders', [CustomerID], "__Value", COUNTROWS('Orders') )
  VAR __Result = COUNTROWS( FILTER( __Table, [__Value] = __Count ) )
RETURN
  __Result
  • AlexaderMilland's avatar
    AlexaderMilland
    Icon for Helper III rankHelper III
    2 years ago

    You mean an index table that just goes from 1 to infinity (or well some max i set) ?