'PowerBi - Sum a measure for each day

I have a measure, Measure A, that is calculated for each day. The visual I am working on allows the user to select a date range with a slicer. I need another measure that will add Measure A for each value.

For example, On Jan 24, 2022, Measure A = 3 and on Jan 25, 2022, Measure A = 4. When the user selects the date range between Jan 24 - Jan 25 for the slicer, I need Measure B = 7 (3 + 4). Below is my DAX for Measure A.

Measure A = CALCULATE(
            IF([Total] = 0,"X",
                CALCULATE(IF(ISBLANK([Present Count]),0,[Present Count])/[Total])
            )
        )

How can I get the value I am looking for Measure B when a user selects multiple days?

powerbi

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'PowerBi - Sum a measure for each day

Sources

Related Questions