cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## measure should give "1" when sum greater dan 0

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?

1 ACCEPTED SOLUTION
Resolver IV

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

Resolver IV

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