Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Create a measure with special filter

As you can see here, the sales are divided into 3 groups

My goal is to make my own measure for each group but I do not know how to do it

In the end I want to create a own measure for:

BUD - Sales
IVC - Sales
MFC -Sales

Please help me asap

Best regards,

Tobias

Well, it would most likely look something along the lines of:

BUD Sales = CALCULATE( SUM('Table'[Sales]) , 'Table'[Type] = "BUD" )

IVC Sales = CALCULATE( SUM('Table'[Sales]) , 'Table'[Type] = "IVC" )

MFC Sales = CALCULATE( SUM('Table'[Sales]) , 'Table'[Type] = "MFC" )

Community Champion

Well, it would most likely look something along the lines of:

BUD Sales = CALCULATE( SUM('Table'[Sales]) , 'Table'[Type] = "BUD" )

IVC Sales = CALCULATE( SUM('Table'[Sales]) , 'Table'[Type] = "IVC" )

MFC Sales = CALCULATE( SUM('Table'[Sales]) , 'Table'[Type] = "MFC" )