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.
Hello, I have the table below with a bunch of columns, each line gives me a product and on another non related table I have the correspondency (from-to) of each of theses products ids and their targets.
I am using the fofllowing DAX to return the "venda categoria espelho"
However as you can see it messes up because it is ignoring the outer filter of date (which is set to march 2021and is also displayed on one of the columns on the table as well) and because of that, it not only fills the table with non filtered data (each row shown after "elim.odor..." is outside the daterange set by the outer filter) but also, per row it is returning me the SUM of all dates instead of only the date defined by that row.
I understand the it is because when filtering for the whole table I end up removing all filters, but i cant get this to work an other way.
Help Appreciated
Solved! Go to Solution.
Managed to make it work, in the end I ended up clearing all filters, creating some variables to store the data I needed for the filters, adding those variables on the tables(date and "venda diária") by splitting the date column into year and another column for month. And using those variales as joinned arguments on the filter function using the AND function (&&)
Managed to make it work, in the end I ended up clearing all filters, creating some variables to store the data I needed for the filters, adding those variables on the tables(date and "venda diária") by splitting the date column into year and another column for month. And using those variales as joinned arguments on the filter function using the AND function (&&)
Instead of clearing all filters on the table with ALL('Venda Diária'), maybe try only clearing the specific filters you do want to be cleared.
I want to kee just the date, but i cant get REMOVEFILTERS to work
By adding another condition to the filter i get rid of the extra lines, but the values are still wrong for some reason it is summing up the full period
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |