Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good
I am trying to get a piece of data through a metric using the switch function and several variables. The problem I have is that depending on which week the measure works well or not.
I explain I am trying to put in a measure that depending on the sector and the market the objective to add is one column or another. The problem I have is that some of them put the data well while others do not. I attach the measure created and the result that comes out and the one that should come out.
I have already managed to solve the problem.
As you can see in the image, choosing the "Export" market and the "Hygienic" sector, the data that appear in "Objectives by market and Sector" Should be the same as "Objective 2021 international hygienic". What I do not understand well is why in some weeks the data is fine and yet in others it is not... I've been trying all afternoon to figure out why but I can't find a solution.
If you can help me I would appreciate it.
Thank you
PS: I have managed to fix the problem by taking the sector and the market to separate tables. It can be put as "solved"
Hi @Syndicate_Admin ,
You can provide your sample file after you have modified the sensitive information by the following ways, thank you.
How-to-provide-sample-data-in-the-Power-BI-Forum
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Well, it seems that I have not managed to solve the problem.
As soon as I want to create a graph with the capture of sales of this year, last year and with respect to the objective (the measure that I have set) making a filter in the year I do not get the data to do it well. I can't attach the file as it's company data. I'm going to try to modify some data and upload the file.
Thank you
Hi @Syndicate_Admin ,
Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@Syndicate_Admin I'm not sure what your DAX Looks like for the measures you're referencing, but based on your solution it is likely related to the way you've designed the filters in the individual measures. Putting them in separate tables enables you to do more advanced filtering.
See if these blogs help:
https://excelwithallison.blogspot.com/2021/09/advanced-filter-or-vs-and.html
https://www.sqlbi.com/articles/expanded-tables-in-dax/
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |