Selectedvalues when nothing is selected

[CarlsBerg999]

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])))

[v-shex-msft]

Hi @CarlsBerg999,

Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Jihwan_Kim]

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!!

[amitchandak]

@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))