Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello all,
I've tried to put this in many ways by my own, but i'm still struggling to solve this problem. Sorry by advance if it seems like a beginer question. I hope somebody knows the answer here. I have a measure calculation rule which is :
Solved! Go to Solution.
Thanks lot for your help,
I found the solution it's :
Hi @Anonymous ,
Can you give some more details on your isse.
If possible, can you give a sample data of your tables and an expected result example
Thanks lot for your help,
I found the solution it's :
Maybe try something like this:
Rouge2 =
SUMX (
VALUES ( 'Table2'[C1] ),
CALCULATE (
VAR AA =
QUOTIENT ( SUMX ( 'Table2', 'Table2'[Xp] - 'Table2'[prérequis] ), 12 ) + 1
VAR BB =
IF ( AA >= 5, 5, AA * SUMX ( 'Table2', 'Table2'[Weight] ) )
RETURN
BB,
Codetable2[Couleur] = "R"
)
)
Hi Antriksh Sharma,
Thank you for your reply and the tips for writting in dax.
Unfortunately it's not working because I need in BB var that the 1st condition equal to 5 must be multipied by Table2[Weight] also.
😕
However, here is some data sample
Xp | Prérequis | Weight | Points(Rouge2) | Competencies | |
Value 1 | 36 | 12 | 10 | (Q(36-12,12)+1)*10=30 | C1 |
Value 1 | 72 | 12 | 5 | (Q(72-12,12)+1*5 = 25 | C2 |
Value 1 | 6 | 12 | 10 | 0 | C3 |
User | Count |
---|---|
15 | |
9 | |
8 | |
6 | |
5 |
User | Count |
---|---|
31 | |
18 | |
15 | |
7 | |
5 |