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

Resolver IV

Help Writing a Measure

Hello,

I need some help with writing a measure to get the specific desired result.

Please find below the raw data along with the output that I am looking for.

Raw Data :

 Date Name Hours Category 1/3/2020 Sam 7.5 Cat 1 1/2/2020 Sam 7.5 Cat 1 1/4/2020 Sam 5 Cat 1 1/4/2020 Sam 5 Cat 2 1/4/2020 Sam 5 Cat 3 1/4/2020 Sam 5 Cat 4 1/4/2020 Sam 5 Cat 5 1/4/2020 Sam 5 Cat 6 1/2/2020 Sam 7.5 Cat 3 1/2/2020 Sam 7.5 Cat 7 1/3/2020 Sam 7.5 Cat 8 1/3/2020 Sam 7.5 Cat 9 1/3/2020 Sam 7.5 Cat 10 1/3/2020 Sam 7.5 Cat 6 1/2/2020 Sam 7.5 Cat 6 1/3/2020 Sam 7.5 Cat 11 1/3/2020 Sam 7.5 Cat 3 1/2/2020 Sam 7.5 Cat 2 1/3/2020 Sam 7.5 Cat 2

Desired Output :

 Output Name Total Hours Sam 20 Cat 1 20 Cat 2 20 Cat 3 20 Cat 4 20 Cat 5 20 Cat 6 20 Cat 7 20 Cat 8 20 Cat 9 20 Cat 10 20 Cat 11 20 Total 20

Output I am getting (This is incorrect)

 Name Total Hours Sam 20 Cat 1 20 Cat 2 20 Cat 3 20 Cat 4 5 Cat 5 5 Cat 6 20 Cat 7 7.5 Cat 8 7.5 Cat 9 7.5 Cat 10 7.5 Cat 11 7.5 Total 20

The measure that I am looking for should calculate the total no. of hours based on the dates irrespective of task category.

Any help on this would be highly appreciated

Thank you

2 REPLIES 2
Anonymous
Not applicable

Pull below measure in your Visual:

``SumOfHours=CALCULATE(SUM(Table[Hours]),ALL(Table[Category]))``

Solution Sage

Start by explaining the logic that gives, say, Cat 7 = 20. There's one line for Cat 7, and it says 7.5.