Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tools12345
Helper I
Helper I

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 week amount on the card and once we select a week on the slicer, It will also display the week amount accordingly. Tried to create a measure but it shows the amount based on the maximum or last week on the table, and not on the current week. Below image and attach is the sample pbix file for testing. Thank you!! sample file powerbi card.png

 

 

2 ACCEPTED SOLUTIONS
tamerj1
Super User
Super User

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

1.png2.png3.png

 

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 )

 

View solution in original post

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

8 REPLIES 8
tamerj1
Super User
Super User

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

1.png2.png3.png

 

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 )

 

Hi @tamerj1 thank you so much! The measure works fine! How can I change the BLANK to 0 value for weeks that don't have an amount instead? 

Hi @tools12345 
The original reply has been updated as per your requirement.

Thank you very much, sir @tamerj1! 🙏🏻 

Jihwan_Kim
Super User
Super User

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.

 

Picture2.png

 

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


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! 

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


Thank you very much, sir @Jihwan_Kim - really appreciate your help and insights! 🙇🏻‍♀️🙏🏻

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors