Forum Discussion

Anno2019's avatar
Anno2019
Helper IV
6 years ago
Solved

how to use Calculate function in combination with values function

Hi Guru's   I use the following formula which returns the "Total Pieces if Trend = "WON". I need to add Value function so that it only looks in "Customer Name".  Not sure how to do this. Total Pi...
Need Help
  • bpsearle's avatar
    bpsearle
    6 years ago

    Hi Anno2019 

     

    Use SUMMARIZE('MainTable', 'MainTable'[Customer Name]) will create a new table with just the customers in. You can then add separate calculated columns to replace the measures you have. If you need to you can add aggregations in the SUMMARIZE. It will make that statement more complicated to follow. I like breaking things out into separate calculated columns so you can test each individual DAX statement.

     

    See how you get on, if you get stuck let us know

     

    Thanks, Brian

Anno2019's avatar
Anno2019
Helper IV
6 years ago

bpsearle 

 

My data has over 100 000 lines.

 

Ok, so aggregated calculated table, have not explored that yet.

I run through a video on how to.

bpsearle's avatar
bpsearle
Resolver II
6 years ago

Hi Anno2019 

 

Use SUMMARIZE('MainTable', 'MainTable'[Customer Name]) will create a new table with just the customers in. You can then add separate calculated columns to replace the measures you have. If you need to you can add aggregations in the SUMMARIZE. It will make that statement more complicated to follow. I like breaking things out into separate calculated columns so you can test each individual DAX statement.

 

See how you get on, if you get stuck let us know

 

Thanks, Brian

  • Anno2019's avatar
    Anno2019
    Helper IV
    6 years ago

    bpsearle, thank you so much.  Will absolutely try this approach!!

    • bpsearle's avatar
      bpsearle
      Resolver II
      6 years ago

      Hi Anno2019 

       

      No problem, it's great being able to help ğŸ™‚

       

      Thanks, Brian