Forum Discussion
tools12345
Helper I
Helper IHow to set value in card based on week value
Hi everyone here in the community, we would like to ask for your insights and help, we have a specific card and a slicer with week. One requirement is that we should be able to display the current we...
Hi tools12345
Here is th sample file with the solution https://we.tl/t-NAIGSrO6dsSelected Week Value = VAR SelectedWeek = COALESCE ( SELECTEDVALUE ( data1[Week] ), WEEKNUM ( TODAY ( ) ) - 1 ) VAR Result = CALCULATE ( SUM ( data1[Account Payables] ), data1[Week] = SelectedWeek ) RETURN COALESCE ( Result, 0 )Hi,
Thank you very much for your message.
Please try the below measure for replacing Blank with zero.
expected outcome: = VAR _thisweeknumber = WEEKNUM ( TODAY (), 21 ) RETURN IF ( ISFILTERED ( date_2022[Week of Year] ), SUM ( data1[Account Payables] ), CALCULATE ( SUM ( data1[Account Payables] ), FILTER ( data1, data1[Week] = _thisweeknumber ) ) ) + 0
tools12345Helper I
Helper IThank you so much, Sir Jihwan_Kim -- truly thankful and you've been one of the active pro I can reach out here in the community 🙇🏻♀️ The measure works fine! How can I change the BLANK to 0 value for weeks that don't have an amount instead? Thank you!
Jihwan_Kim
Super User
Super UserHi,
Thank you very much for your message.
Please try the below measure for replacing Blank with zero.
expected outcome: =
VAR _thisweeknumber =
WEEKNUM ( TODAY (), 21 )
RETURN
IF (
ISFILTERED ( date_2022[Week of Year] ),
SUM ( data1[Account Payables] ),
CALCULATE (
SUM ( data1[Account Payables] ),
FILTER ( data1, data1[Week] = _thisweeknumber )
)
) + 0- tools12345
Thank you very much, sir Jihwan_Kim - really appreciate your help and insights! 🙇🏻♀️🙏🏻