Forum Discussion

maxabele's avatar
maxabele
Frequent Visitor
6 years ago
Solved

Measure Total is Blank

Hi all,

 

I searched the problem but nothing worked for this case.

 

I calculate turnover in a specified date range. The measure shows how many people left during that time. The formula works as it should, but the total is blank. That's the formula (effective date means date of last work day):

 

Staff_Turnover = IFERROR(Calculate(Countrows(Worker_Data);
Filter(Values(Worker_Data[Effective Date]);'Worker_Data'[Effective Date]<=Min('Date'[Date]));
Worker_Data[Effective Date]<>BLANK());BLANK())

Any help is greatly appreciated.
 
Thanks in advance and best,
Max
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi maxabele 

    As tested, it works on my side. 

    No relationship for two tables.

     

    Staff_Turnover =
IFERROR (
    CALCULATE (
        COUNTROWS ( Worker_Data ),
        FILTER (
            VALUES ( Worker_Data[Effective Date] ),
            'Worker_Data'[Effective Date] < MIN ( 'Date'[Date] )
        ),
        Worker_Data[Effective Date] <> BLANK ()
    ),
    BLANK ()
)


or
Measure =
IFERROR (
    CALCULATE (
        DISTINCTCOUNT ( Worker_Data[worker id] ),
        FILTER (
            Worker_Data,
            [Effective Date] <> BLANK ()
                && [Effective Date] < [mindate]
        )
    ),
    BLANK ()
)

     

    Please make sure you turn on the "total" option,

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

7 Replies