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 a relationship on Cat name between Cat and Question and a relationship on Question ID between Question and Choices.

I have a Measure to calculate the Min and the Max points that you can get per question. Both take into account the weight. (multiplier)

_MinPQ =
VAR QuestionType = SELECTEDVALUE('Questions'[Weight Type])
VAR Multiplier = SELECTEDVALUE('Questions'[WeightQ])

RETURN
IF(
QuestionType = "Single",
MINX('Choices', 'Choices'[Weight Response]) * Multiplier,
0 * Multiplier
)

_MaxPQ =
VAR QuestionType = SELECTEDVALUE('Questions'[Weight Type])
VAR Multiplier = SELECTEDVALUE(Questions[WeightQ])

RETURN
IF(
QuestionType = "Single",
MAXX('Choices', 'Choices'[Weight Response]) * Multiplier,
SUM('Choices'[Weight Response]) * Multiplier
)

Now in a way or another, on top of the question, I would love to have the Min and Max points but for the category and for the total (all)

Sample of what I expect:

Maybe it's late, I've spend a lot of hours on this, always dificlult when we start 😕

Link to a sample file:

https://drive.google.com/file/d/1llvqMNp56MwyCxWNv501GXWIwE52OIgo/view?usp=share_link

Thanks in advance for your precious help.

Chris