create dax measure to remove context filter
hi everyone im trying to create a measure that remove the conext filter in a table visual with if statement condition i was trying to use 'all' function to remove the filter from the column but still not working. current measure : calculate(sum('categories trans'[achievement]), all('categories trans'[Base_type]) in the above example , i want to ignore the filter by (base_type) column in one category (zeed) and keep it for the other categories. for example: if category= 'zeed' i want the achievement measure to return 441 and for other categories i want the achievment measure to return same values above.Compare two rows and return the one with the earliest date Power Bi
Hi, I have a table called "Jira tickets", in which I have multiple rows for the same ticket, as you can see below in the sample data: If we take for example Ticket 1, how can I compare the rows to take only the first Sprint when this ticket was in status "Done", based on the Status date? In this case, to have a calculated column that will say "include" for Sprint 7 (08-Sep-22) and "exclude" for Sprint 8 (04-Oct-22). I will have to do the same thing for the status "To Do". Thank you very much! 😊creating measure to calculate the average of sum of value
I have a table and I want to create measure to calculate the monthly average of total cost per each day so 1- I want to sum the total value per each date 2- I want to get average of the sum per each month (the number of days per each month are not equal ,I mean there are 5 dates in august but in sepryember only 4 ....etc) I hope my question is clear enough Best Regards
LOOKUPVALUE not reporting all availabe data
Dear all, i have 2 tables whre i need to combine the data set. I tried to achive this by RELATED or LOOKUPVALUE but both approaches report only a part of the available data. picture I: report table which contains the LOOKUPVALUE fxt the second table is containing the necessary data. As you may see the secontable is containig the required information but it is not reporting it back. Both tables are sorted by p/n picture2: table for lookupvalues Does somebody have an i dear what i need to change in order to reiceive the complete data set. Thank you and best regards!
