Forum Discussion

sborowiec13's avatar
sborowiec13
Regular Visitor
8 years ago
Solved

Creating a new table with the first calculated value for each field name

I have a variety of different customer numbers in my data and using fixed calculations, I have been able to get the numbers I need on a category basis (had to do a couple of fixed calculations on age...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi sborowiec13,

     

    If the sample you posted is the data source, you can try out a measure like this.

    Measure =
SUMX (
    SUMMARIZE (
        'Table1',
        'Table1'[Customer],
        Table1[Value],
        "Unique", DISTINCT ( 'Table1'[Value] )
    ),
    [Value]
)

    Creating_a_new_table_with_the_first_calculated_value_for_each_field_name

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi sborowiec13,

 

If the sample you posted is the data source, you can try out a measure like this.

Measure =
SUMX (
    SUMMARIZE (
        'Table1',
        'Table1'[Customer],
        Table1[Value],
        "Unique", DISTINCT ( 'Table1'[Value] )
    ),
    [Value]
)

Creating_a_new_table_with_the_first_calculated_value_for_each_field_name

 

Best Regards,

Dale