Forum Discussion
Card Visuals with DAX not Showing Correct Data
Hello all,
I'm hoping for some help. I have the following DAX in a card visual -
Total Requested = IF(
And I have slicer linked to it which I have as "week commencing" to show me info for the total requested for the week selected. I have various other cards also layed out in the same format for different tasking codes. Here is my problem -
Is there something I need to add to the DAX in the cards? I don't understand why it shows me the right totals for some weeks but not others.
Any help welcome and I hope I've given enough info.
4 Replies
- amitchandak
Super User
Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
amitchandak Thanks for your reply.
And a very brief sample data below -Direction TaskingCode Outbound SSM Outbound SSM Return MFM Outbound UFM Outbound ACM6 Return ACM24 I hope some of this helps, if there is anything else let me know, I feel already I'm being quite vague due to the sensitivity.
Thanks.
Anonymous
There is no week or date column, please add more details. We Also provide the expected output based the above sample data.
Read this post to describe your problem:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Paul Zheng _ Community Support Team
Hello all,
Just wanted to say that I solved the problem and for anything reading, I'd like to suggest the following, in order, whenever you come across an issue -
1) - Check the data uploaded is correct and the most up to date (this was my issue).
2) - Then check the relationships.
3) - Then check your DAX for further problems.Thanks for everyones replies.
