Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi @Norbertus,
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
Hi @Norbertus,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |