Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX expression aggregation

Hello community,   I am working with daily records stored mostly as durations in seconds. I am using DAX to DIVIDE numerators and denominators to return percentage values. Once I put these values i...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Anonymous 

     

    You can try the following methods.

    Column:

    value = IF([numerator]=0,0,DIVIDE([numerator],[denominator]))

    Measure:

    Measure =
IF (
    HASONEVALUE ( 'Table'[report_date] ),
    SUM ( 'Table'[value] ),
    DIVIDE ( SUM ( 'Table'[numerator] ), SUM ( 'Table'[denominator] ) )
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

gauthamboppana's avatar
gauthamboppana
Solution Specialist
4 years ago

Anonymous  - If you want to look at weekly values, its better to create a calculated column in your table for week start date and then  use it in the Matrix (instead of the report date column).

WeekStart=[report_date] - WEEKDAY ([report_date], 3 )



Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

Thank you very much !



Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you for the assistance! I had another question come from trying to return values for the current week where the value returned is calculating much higher than it should be. Would this calc column solve for that?
Example: None of these values should be higher than 100%