Forum Discussion

DLHGKreport's avatar
DLHGKreport
New Member
1 year ago

DAX formula help subtotals

Hey all,   I wrote a DAX formula, but when i select induvidual Konto's in a slicer i get the right totals, but when i select mutiple the totals and column subtotals are wrong. I can't figure it out...
Need Help
ZhangKun's avatar
ZhangKun
Icon for Super User rankSuper User
1 year ago

If the measure [Dayvalue] is a simple aggregation, this measure is fine (because the filtered rows are only traversed once), but if it contains complex logic, then each grouping (SUMMARIZE and the axis in the chart) must be done with caution.

In the absence of specific data, only simple suggestions can be given.

  • DLHGKreport's avatar
    DLHGKreport
    New Member
    1 year ago

    Im prohibited to share the data but i can show you that the calculation is not working like intended: 


    The [dayvalue] is the following measure:

    Dayvalue =
    VAR _days = [Aantal dagen]
    VAR _dayrate = CALCULATE([Dagprijs], REMOVEFILTERS('dagen 2024'[Konto]))
    RETURN
    _dayrate * _days