Forum Discussion

Akhil01's avatar
Akhil01
Frequent Visitor
7 years ago
Solved

Revenue for distinct Product

Hi All,

 

The logic should be if the product name is different give me the total of the revenue if the product name is similar give me the distinct revenue of the product." 
Below is the screenshot for better understanding.

 

The Revenue should be 291182.400

 

 

 Regards,

Akhil.

General Comment
Need Help
Show and Tell
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Akhil01 ,

     

    To create a measure as below.

     

    Measure = 
SUMX (
    SUMMARIZE ( Table1, Table1[product_name], Table1[Revenue] ),
    Table1[Revenue]
)

    Pbix as attached.

     

1 Reply

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Akhil01 ,

     

    To create a measure as below.

     

    Measure = 
SUMX (
    SUMMARIZE ( Table1, Table1[product_name], Table1[Revenue] ),
    Table1[Revenue]
)

    Pbix as attached.