Revenue for distinct Product

[Akhil01]

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.

[v-frfei-msft · Accepted solution]

Hi @Akhil01 ,

To create a measure as below.

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

Pbix as attached.