Forum Discussion

Chris_noob's avatar
Chris_noob
Frequent Visitor
2 years ago
Solved

Score calculation help, stuck with SUMIF equivalent in Excel

Hi Forum,   I'm working on a report to calculate scores and I'm a little bit stuck.   My report calculate scores with a weight factor. It's composed of 3 tables Cat, Question and Choices. I have...
Need Help
  • Chris_noob's avatar
    Chris_noob
    2 years ago

    Hi AllisonKennedy 

     

    Thank you very much for your help. I found an option, I added a Matrix, with the calculated columns and summerized using sum and it did the trick 😉

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
2 years ago

Chris_noob  

 

If you're using it in the same visual as your post, you can use:

 

MinCat = calculate ( [_MinPQ] , ALL( Question[Question] ) )

MinTotal =  calculate ( [_MinPQ] , ALL(  ) )

 

and then the same pattern for the Max

Chris_noob's avatar
Chris_noob
Frequent Visitor
2 years ago

Thanks AllisonKennedy 

 

I just tried but unfortunately, unless I'm doing something wrong but it's not fully working as expected 😞

 

Here's the result: