Forum Discussion

CarlsBerg999's avatar
CarlsBerg999
Helper V
5 years ago

Selectedvalues when nothing is selected

Im trying to get a count of weeks since 1.3.2021 from my datetable. However, if the user clicks visuals, it should count how many weeks the user has selected. The DAX code below works, when the user has selected weeks from a visual (For example, activated week1 and week2). However, it returns blank if no weeks are selected. How do i get the formula to return weeks since 1.3.2021, if no week selection is made? It tried adding another filter (= DateTable[Date] >= DATE("2021","3","1"))) But it did not produce the expected result.
 
Weeks Since 1.3.2021 = CALCULATE(DISTINCTCOUNT(DateTable[Week & Week Name]),
FILTER(DateTable,DateTable[WeekName]=SELECTEDVALUE(DateTable[WeekName])))


Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    CarlsBerg999 , Check with allselected

     

    Weeks Since 1.3.2021 = CALCULATE(DISTINCTCOUNT(DateTable[Week & Week Name]),
    FILTER(DateTable,DateTable[WeekName] in allselected(DateTable[WeekName])))

     

     

    or

     

    Weeks Since 1.3.2021 =

    var _max  = maxx(allselected(DateTable),DateTable[WeekName])

    return

    CALCULATE(DISTINCTCOUNT(DateTable[Week & Week Name]),
    FILTER(DateTable,DateTable[WeekName] = _max))

     

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, CarlsBerg999 

    Please correct me if I wrongly understood.

     

    If readers do not select anything in the slicer, you want to show XXXXXX.

    In this case, could you please try below?

     

     

    Weeks Since 1.3.2021 =
    If( isfiltered(DateTable),
    CALCULATE(DISTINCTCOUNT(DateTable[Week & Week Name]),
    FILTER(DateTable,DateTable[WeekName]=SELECTEDVALUE(DateTable[WeekName]))),
    XXXXXX)
     
    I hope it helps.
     
    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!