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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Portfolio | FTE Breakdown |
A | 9 |
B | 21 |
C | 30 |
D | 23 |
E | 4 |
F | 3 |
TOTAL | 90 |
Portfolio | Monthly Recognitions Sent | monthly Sent% |
A | 5 | 0.06 |
B | 3 | 0.03 |
C | ||
D | 5 | 0.06 |
E | ||
F | ||
Total | 13 | 0.14 |
Solved! Go to Solution.
Hi, I am not sure how your semantic model looks like, but please try something like below if it works.
Sent % =
VAR Numerator =
CALCULATE (
COUNT ( 'Received by Team'[Recognition_PK ID] ),
'Received by Team'[Nominator Portfolio (sent)] <> "",
'calendar'[Rank] = 1
)
VAR Denominator =
SUM ( FTE_Sheet[FTE Breakdown] )
RETURN
DIVIDE ( Numerator, Denominator )
Thanks Jihwan_kim for the solution, This logic works
Hi, I am not sure how your semantic model looks like, but please try something like below if it works.
Sent % =
VAR Numerator =
CALCULATE (
COUNT ( 'Received by Team'[Recognition_PK ID] ),
'Received by Team'[Nominator Portfolio (sent)] <> "",
'calendar'[Rank] = 1
)
VAR Denominator =
SUM ( FTE_Sheet[FTE Breakdown] )
RETURN
DIVIDE ( Numerator, Denominator )
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.