Forum Discussion

mmahoney045's avatar
mmahoney045
Regular Visitor
2 years ago
Solved

Create Measure From Virtual Table

Hello,   I am attempting to create a measure that will return the distinct count of a specific type of customer (New Tank Distributor) that is set up in any given year. After attempting simple meas...
Need Help
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    well, you can t use summarizecolumns in measure 

    try using addccolumns ( summarize ( .. )   instead .

     

    and for the return, just return   aggregation without the {  } .

    the { }  were only needed for the query not to be used in the measure. 

     

    hope this makes sense. 

    mmahoney045 

Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

mmahoney045 

 

VAR _aggtable =
maxx(,
        FILTER(
            GROUPBY(
                _summarytable,
                [Distributor Type],
                "Number Of Customers", COUNTX( CURRENTGROUP(),1)
            ),
        [Distributor Type]="New Tank Distributor"
        ),
        [Number Of Customers]
        )

 

should be something like this.

 

mmahoney045's avatar
mmahoney045
Regular Visitor
2 years ago

Ah, sorry. the error states: The 3 argument to the MAXX function contains a flag that is not supported.

 

Its bizarre that converting a table value to scalar is this difficult. 

  • Daniel29195's avatar
    Daniel29195
    Community Champion
    2 years ago

    mmahoney045 

    can you please share a screenshot of the code ? 

     

    • mmahoney045's avatar
      mmahoney045
      Regular Visitor
      2 years ago

      Here is the code:

       

       

      VAR _aggtable =
              MAXX(,
                  FILTER(
                      GROUPBY(
                          _summarytable,
                          [Distributor Type],
                          "Number Of Customers", COUNTX( CURRENTGROUP(),1)), [Distributor Type]="New Tank Distributor"),[Number Of Customers])

      EVALUATE
      _aggtable