Forum Discussion

BrianL_'s avatar
BrianL_
Regular Visitor
2 years ago

DAX not working with Measure but does work with regular numbers

Hi Everyone,   Problem: I am calculating percent billability for a dashboard and need the number of hours to be dynamic so slicers work with this eqution. My equation essentially gets the percent...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi BrianL_ ,

Based on the information you provided, the issue seems to be related to how DAX handles the calculation of metrics versus static values. This may result in different behaviour when performing calculations across different rows or under different filter contexts in the slicer application. You can refer to the following steps to troubleshoot the issue:

1. Ensure that the data types all return numbers and that no implicit data type conversions have occurred that could affect the calculation.

2. Context conversion using CALCULATE can solve the problem of measure behaving abnormally in some calculations.

Percent Billability =
DIVIDE (
    100 * CALCULATE ( SUM ( Harvest[Billable Hours] ) ),
    Harvest[NumOfWorkdays] * 8
)

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.