Grand total for measure does not show in total row or in card visual

[rixmcx59]

Hello all, I have three measures stored in a measures table, Start, End and Duration. The duration measurse is a simple DateDiff/days using start and end. If I drop duration in a card it's blank until I filter on a row, then it shows the value I selected. Also in a table visual the Totals do not show. how do I get this measure to calculate the entire column. I can post the end date if needed.

SUMX(VALUES(zMeasures),zMeasures[Duration]) 

Duration = 

DATEDIFF(zMeasures[StartDate],zMeasures[EndDate], DAY)

StartDate =

VAR _currentBk =

    MIN(FactTable[Bk.BkIndex])

VAR _currentTask =

    MIN(FactTable[Tasks.TaskIndex])

RETURN

    CALCULATE(

        MIN(FactTable[Created]),

        FILTER(

            ALL(FactTable),

            FactTable[Bk.BkIndex] = _currentBk && FactTable[Tasks.TaskIndex] = _currentTask

        )

    )

[rixmcx59]

Thank you, the SUMX(VALUES( DAX worked for me and returned the correct number. However after checking the result I found a serious flaw in my Start and Finish DAX formulas. My model assumed that each customer would progress through the buckets in order like Phase 0 to 5 and possibly go into Backlog or No Response. The problem is the created date does not represent a bucket change 100% of the time. I need to group by bucket then capture the MIN and MAX date, which is not happening, the records in Bold/Red are being ignored in my DAX measures. Thanks for any help.

ID	Task	Bucket	Start	End	Duration	Created
1	CustomerD	Phase 0	1/12/2023	1/18/2023	6	1/12/2023
2	CustomerD	Phase 0	2/9/2023	2/26/2023	17	2/9/2023
3	CustomerD	Phase 2	1/18/2023	2/9/2023	22	1/18/2023
4	CustomerD	Phase 3	2/27/2023	3/12/2023	13	2/27/2023
5	CustomerD	Phase 3	2/26/2023	3/12/2023	14	2/26/2023
6	CustomerD	Phase 4	3/20/2023	5/2/2023	43	3/20/2023
7	CustomerD	Phase 4	3/12/2023	5/2/2023	51	3/12/2023
8	CustomerA	Backlog	1/12/2023	2/8/2023	27	1/12/2023
9	CustomerA	No Response	4/13/2023	5/2/2023	19	4/13/2023
10	CustomerA	Phase 0	2/27/2023	3/8/2023	9	2/27/2023
11	CustomerA	Phase 0	2/8/2023	3/8/2023	28	2/8/2023
12	CustomerA	Phase 3	3/8/2023	4/13/2023	36	3/8/2023

[amitchandak · Accepted solution]

@rixmcx59 , Based on the columns in visual or you want to group , you need try like

SUMX(VALUES(Fact[Column]),zMeasures[Duration])

SUMX(SUMMARIZE(Fact, Fact[Column1], Fact[Column2),zMeasures[Duration])

or

SUMX(Fact,zMeasures[Duration])