Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
This randomly happens. To better illustrate, this is the bug that is occuring. The green line is the 100% line. The data point outside of the 100% grid is GC.
All of those points are 100% (percentage format). The visual uses a calculated measure to display data based on a selected filter. In the screenshot above, the "Billable Mandays" value is selected in the filter which should display the value of the ~Billable Utilization measure.
!Utilization = SWITCH( HASONEVALUE('Utilization Switch'[Switch]), MIN('Utilization Switch'[Switch]) = "Billable Utilization", [~Billable Utilization], MIN('Utilization Switch'[Switch]) = "Non-billable Utilization", [~Non-billable Utilization], [~Billable Utilization] )
The value is computed by a measure like so:
~Billable Utilization = CALCULATE( DIVIDE(SUM([Billable Mandays]), SUM([Available Workdays])) )
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.