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.
I create a measure but the total in table does not match total on card.
My measure:
Hoping if you apply the same Filter HoursAudit > 0 to the Card Visual, you should end up with the same value.
The next thing I would do is change the card visual to a table and compare the records in that table with the one you have posted.
If these don't resolve the issue, please paste sample data as text (not as a picture) or attach a sample pbix file and I will try to have a closer look.
Regards,
@rsbin Thank you for your response and time.
my measure :
You can use the Filter Pane to apply [Hours Audit] > 0. Apply this Filter to both your Table and your Card Visual.
Or, try this adjustment to your Measure:
PercentageTimeAudit = DIVIDE(SUMX(FILTER('Time Utilization', 'Time Utilization'[Stage] = "F&A-TE-Audit" && [Hours Audit] > 0 ), 'Time Utilization'[Hours]), [Total Hours])
it does not appear i am able to add filter to the card.
Also, formula is still calculating operators with 0 [hours audit]
Hi @Coryanthony
You can try the following measure
PercentageTimeAudit =
CALCULATE (
DIVIDE (
SUM ( 'Time Utilization'[Hours Audit] ),
SUM ( 'Time Utilization'[Total Hours] )
),
'Time Utilization'[Hours Audit] > 0,
'Time Utilization'[Stage] = "F&A-TE-Audit"
)
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you
Are you able to attach your pbix file?
Edit: I have attempted to replicate some of your sample data
Please see pbix file attached. Seems to work on my side.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |