Forum Discussion

Revati25's avatar
Revati25
Icon for Advocate I rankAdvocate I
6 months ago

Running Total Issue in Power BI

Hi, I have one table where I have worker start date and end date. This table has unique values only. So for each worker there is one start date and one end date.  The start date of the worker is co...
Need Help
Tips and Tricks
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
6 months ago

Hi,

Please correct me if my sample pbix file is not similar as what you have, but it seems like your dax measure works.

Please check the below and the attached pbix file.

 

 

Count of workers: = 
VAR CurrentDate =
    MAX ( 'Calendar'[Date] )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( 'Worker Table'[ID] ),
        'Worker Table'[GEOGRAPHY]
            IN { "Poland", "Spain", "France", "Australia", "Italy" },
        'Worker Table'[Active/Ended] = "Active",
        FILTER ( ALLSELECTED ( 'Calendar'[Date] ), 'Calendar'[Date] <= CurrentDate )
    )