Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
Solved! Go to Solution.
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 )
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
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 )
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,
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 )
)
)
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
Thank you very much, sir @Jihwan_Kim - really appreciate your help and insights! 🙇🏻♀️🙏🏻
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
8 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
9 |