Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello guys.
I need to create a rule that tells me if there are 3 or more PN's for the same Case Number.
If it is 3 or more, you need to reform the message: "Call the TSE"
If below 3: "Follow with Service"
Thanks.
Ejemplo:
Solved! Go to Solution.
Hi @carloshluiz ,
You seem to have created a calculated column, if you want a calculated column, try like:
Result =
VAR _COUNT =
CALCULATE (
DISTINCTCOUNT ( 'Parts Order Line'[PN] ),
FILTER (
ALL ( 'Parts Order Line' ),
'Parts Order Line'[CaseNumber] = EARLIER ( 'Parts Order Line'[CaseNumber] )
)
)
VAR _RESULT =
IF ( _COUNT >= 3, "Call the TSE", "Follow with Service" )
RETURN
_RESULT
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
@carloshluiz try this measure:
Hi @carloshluiz ,
I send you my pbi file with a simplified model. Do you have other columns in your table?
https://1drv.ms/u/s!Aj45jbu0mDVJiz-8PUm2VToAVzL2?e=DekHub
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @carloshluiz ,
try this measure
Measure =
VAR _CurrentCase = SELECTEDVALUE('Facts51'[Case Number])
VAR A =
COUNTROWS(
FILTER(ALL('Facts51'),
'Facts51'[Case Number] = _CurrentCase
)
)
RETURN
SWITCH(TRUE(),
A>=3,"Call the TSE",
"Follow with Service"
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It didn't work, only an answer appeared.
Hi @carloshluiz ,
You seem to have created a calculated column, if you want a calculated column, try like:
Result =
VAR _COUNT =
CALCULATE (
DISTINCTCOUNT ( 'Parts Order Line'[PN] ),
FILTER (
ALL ( 'Parts Order Line' ),
'Parts Order Line'[CaseNumber] = EARLIER ( 'Parts Order Line'[CaseNumber] )
)
)
VAR _RESULT =
IF ( _COUNT >= 3, "Call the TSE", "Follow with Service" )
RETURN
_RESULT
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
User | Count |
---|---|
79 | |
76 | |
68 | |
66 | |
53 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |