measure should give "1" when sum greater dan 0

[Anonymous]

Hi

I need a table with the sum of worked hours (value), but the value has to be "1" if the total is greater dan 0

            week 1 | week 2 | week 3

John        50    |    0        |    32 

Peter       0      |   10       |    15

The result should be:

            weak 1 | week 2 | week 3

John        1      |    0        |    1 

Peter       0      |    1        |    1

Do you have a suggestion?

[mehaboob557 · Accepted solution]

Hi @Anonymous,

I am assuming Jhon and Peter column name as name.

i am writing 4 measures,

Measure = SUM(Table1[week1])
 

Measure 2 = IF([Measure]>0,1,0)

 

Measure3 = SUM(Table1[week2])
 

Measure 4 = IF([Measure3]>0,1,0)

Use Measure 2 and Mease 4 in table visual.. u will get the final output

OR

If you want to calculate with the each name,

week measure= CALCULATE(SUM(Table1[week1]), ALLEXCEPT(Table1,Table1[name]))

Final Measure = IF([week measure]>0,1,0)

Find the pbix file here