Skip to main content
cancel
Showing results for 
Search instead 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

Reply
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
mehaboob557
Resolver IV
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 

View solution in original post

1 REPLY 1
mehaboob557
Resolver IV
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 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.