Forum Discussion

Enam's avatar
Enam
Regular Visitor
2 years ago
Solved

DAX help needed

Here is the link to a sample pbix file https://drive.google.com/file/d/1J4C3V4A98IwZpQbubTlF6tPWlwXQG2Ir/view?usp=sharing or to Excel file https://docs.google.com/spreadsheets/d/18SXUttN51bZLLPfKXnV...
Need Help
Enam's avatar
Enam
Regular Visitor
2 years ago

Hi Gabry ,

Now the dispacth is ok but the total disappear

 

 

  • Gabry's avatar
    Gabry
    Icon for Super User rankSuper User
    2 years ago

    I see, adjust the measure like this:

     

     

    Count of Activities Measure =
    VAR _mon = SELECTEDVALUE('Mondays'[Monday])
    VAR _ac = SELECTEDVALUE(Classeur[Activity],"Total")
    RETURN
    IF(_ac="Total",
    CALCULATE(
        COUNTROWS(Classeur),
        ALL(Classeur),
        Classeur[Start_Date] <= _mon,
        Classeur[End_Date] >= _mon)
    ,
    CALCULATE(
        COUNTROWS(Classeur),
        ALL(Classeur),
        Classeur[Start_Date] <= _mon,
        Classeur[End_Date] >= _mon,
        Classeur[Activity] = _ac
    )
    )