Filter a measure by measure

[Ibadkhan]

Hello everyone!

Hope you all are fine.

I want some help related to measure filtering. I have Measue A in which there is calculated quantity  and Measure B in which there is calculated amount. I want filter amount .i.e. Measure B by quantity in Measure A having values greater than 1, in simple words: 

Sum Measure B , Filter Measure A > 1 .

Thanks.

[v-yingjl · Accepted solution]

Hi @Ibadkhan ,

Based on your description, I have created this sample table:

MeasureA:

MeasureA =
CALCULATE (
    COUNT ( 'Table'[Class] ),
    FILTER ( ALL ( 'Table' ), 'Table'[Class] IN DISTINCT ( 'Table'[Class] ) )
)

MeasureB:

MeasureB =
CALCULATE ( SUM ( 'Table'[Sales] ), FILTER ( 'Table', [MeasureA] > 1 ) )

 

Attached a sample file in the below, hopes to help you.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Ibadkhan , Can you share sample data and sample output in table format?  Then I can tell. Usually depening on need we use a context.

[amitchandak]

@Ibadkhan , You need some context / gorup by for that

//Where should mesure gorup to filter

SumX(filter(values(Table[Column]) , [Measure A] > 1  ) ,[Measure B] )

Assumed data should group at Table[Column] and then filter measureA. In case you need at the row level, use  some unique row id

[Ibadkhan]

@amitchandak  which colum should I use?