Forum Discussion

Helper I

4 years ago

Solved

How 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...

tamerj1

4 years ago

Hi tools12345
Here is th sample file with the solution https://we.tl/t-NAIGSrO6ds

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

Jihwan_Kim

4 years ago

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

Jihwan_Kim

Super User

4 years ago

Hi,

I am not sure if I fully understood the data model, but please try to write the below measure and put it into the card visualization.

Please check the below picture and the attached pbix file.

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

sample test file only.pbix260 KB

tools12345
Helper I
4 years ago
Thank 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
  4 years ago
  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
  - tools12345
    Helper I
    4 years ago
    Thank you very much, sir Jihwan_Kim - really appreciate your help and insights! 🙇🏻‍♀️🙏🏻