Sum of a measure with boolean values

[Anonymous]

Hi,

I have a measure that calculates volume for a particular date by SAP ID - Measure1.

I want to use Measure1 to calculate the total count of SAP ID with volume >0 to create another measure.

I tried using

Measure2=

var Count_helper=IF([Measure1]>0,1,0)

return SUMX(VALUES('Table'),Count_helper)

But it did not work

Measure1=var m1=MAX(date_test[year_month])
var Currentdate=DATE(year(m1),MONTH(m1)-12,DAY(m1))
var Previousdate=DATE(year(Currentdate),MONTH(Currentdate)-12,DAY(Currentdate))
var Result = CALCULATE(
    SUM('Datas Vol'[Total Volume]),FILTER(Dates,Dates[date]>=Previousdate && Dates[date]<Currentdate))
return Result

[v-kkf-msft]

Hi @Anonymous ,

Referring to the example above, you can try to create such a measure for your needs:

Measure2 = 
VAR t =
  CALCULATE (
    DISTINCTCOUNT('Table'[Colunmname]),
    FILTER ( 
      ALLSELECTED('Table'), 
      [Measure 1] > 2 
    )
   )
RETURN
  IF ( [Measure 1] > 2, t, 0 )

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

@Anonymous 

Try:

Count = CALCULATE(DISTINCTCOUNT(table [SAP ID]), FILTER(Table, [Measure1> 0))

[Anonymous]

for some reason countrow is not working

[PaulDBrown]

@Anonymous 

Apologies since I saw you wanted the count of unique values. I changed the meaures to:

Count = CALCULATE(
           DISTINCTCOUNT(Table [SAP ID]), 
           FILTER(Table, [Measure1> 0)
)

[parry2k]

@Anonymous not fully clear what is the ask here, post sample data and the expected output to get your answer quickly.

[Anonymous]

ID Volume

1   10

2   20

3   30

4   8

5   7

6   5

7  10

I need to find the sum of the Volume where Volume => 10

Please note Volume here is a measure