Dax - Calculating Sum And Count based on A measure result
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 1 of 1

Thread: Dax - Calculating Sum And Count based on A measure result

  1. #1
    New Member
    Join Date
    Nov 2005
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Dax - Calculating Sum And Count based on A measure result


    Dax - Calculating Sum And Count based on A measure result
    Hi,
    i have made a simple dax calculation which presents the New Customers:

    New Customers = IF([LY Sales LC]>0,BLANK(),IF([Sales LC]>0,[Sales LC],BLANK()))

    i am making a pivot with customer in the row and get the new customers list with sales.


    My question is how to get the number of New Customers (Distinct Count) and Total Sales(Sum) based on the population received by the original measure

    thanks

    [ one way is to create a calculated column that mark new customers but i guess there is a better way using a measure)
    Last edited by eitanhcs; Nov 28th, 2017 at 10:46 AM.

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com