Value from related table
Hi I'm stuck with relatively simple task. I have 2 tables (simplified): Email(EmailId, Subject, Type, CreatedOn) and Task(TaskId, Name, Status, CreatedOn) Each email may have zero to many tasks. Task Status is the Status of the very first related task (if exists). I'd like to display a table with following columns: Email Type, Task Status, Counter. Any help would be appreciated! Regards
Rank by group and order it by another related column table
Hey Community! I have those two tables: Movie_Details - contain: "Major Genre", "Director" Revenue - contain: "ROI" I want to get the movie with the highest ROI for each Major Genre and show the Director's name of the film. The tables are related by column name "Title". I tried to rank by group (Genre) that will be ordered descending by ROI to get all the 1's, but it didn't work. Where did I go wrong? Here's the DAX code: Rank Genre = RANKX(ALLEXCEPT(Movie_Details, Movie_Details[Major Genre]),MAXX(RELATEDTABLE(Revenue),Revenue[ROI]),,DESC) And here's an example of the ranking for the genre "Action" with descending ROI:If a related table column value = x, then return another related table column value
This is a very simple thing that I am trying to do. I have two tables that have a relationship between each other. I just want to say, if tblPricing has "Individual" in the [Pricing Structure] column, then return the adjacent [Price] values from the same table. However, I am getting this silly error about expressions and variables. Can someone please tell me why this error is happening and how I should do a simple lookup like this?
Compare rows from other table to make calculated column in first table
Hi, I have two tables, one with accounts, and one with expenses. In the table with accounts I have an ID, which is linked to the expense table, and I have an account Name, a status and I would like a calculated column which should determine whether or not the account is ready to be closed. Table with accounts: Id Account Status ShouldClose 1 A Active 0 2 B Completed 0 3 C Completed 1 4 D Completed 1 5 E Closed 0 This calculated column, marked with orange should be calculated based on the status and on the second table with expenses. If the current Actual and Posted Revenue and Expense are equal to each other, and the Account = Completed, then the flag should be 1. AccountID Type IsCurrent Rev Exp 1 Actual 1 500 100 1 Posted 1 500 100 2 Actual 1 600 150 2 Posted 1 600 50 3 Actual 0 1000 1000 3 Posted 0 500 500 3 Actual 1 1200 400 3 Posted 1 1200 400 4 Actual 1 1600 800 4 Posted 1 1600 800 5 Actual 1 900 100 5 Posted 1 900 100 E.g. for AccountID 3: Current Rev: Actual 1200 - Posted 1200 = 0 Current Exp: Actual 400 - Posted 400 = 0 Here the flag should be 1, because the Account is Completed. E.g. for Account 2: Current Rev: Actual 600 - Posted 600 = 0 Current Exp: Actual 150 - Posted 50 = 100 Here the flag should be 0, since both are not equal to 0. I hope this makes sense, and that you can help me 🙂KEEP TOTAL NO DATA RELATED
Hello, Anyone could help me? I have a measure that brings me values based on another column of the same table (A). When I add a field from another table (B) it shows only the values that has data of this another table (B). How do I keep the values of table (A) even if they do not have any relation with data of table (B)? Following the screens with the DAX code and tables with its totals. The totals should be the same in 1 and 2. I’ve already tried to apply in the DAX code ALL(), REMOVEFILTERS(), RELATED(), but didn’t work. Regards,
2 Measures on same line graph
I have 2 rolling 14 day average calculations and Im hoping to display them (highlighted) on the same line graph: However I've tried to create a date bridge and another table to relate to and still no luck with either approach. Where it should look more like this: Can anyone help with this? SEE FILE ATTACHED https://www.dropbox.com/s/ksi9fm0kbzpj1hg/Notification%20vs.%20Epi.pbix?dl=0Create a table/matrix with related data of 2 queries
Hi, I'm having this problem: I have this 2 tables and has a relationship 1 to many by OP, I would like to create a column that can lists every "new op" that have the same code of the "old op", I'm thinking in something like this: or something like this it's the same idea but different format, eather of these two should do the work, but so far i can not reach a column like that, any help would be very much appreciate. Thanks.Divide with denominator as measure and numerator as related values from different table
Hi I am trying to define measure that gives "cost per kilometer" I have a fact table having [Equipment], [Loaded Distance] and [Deadhead Distance] column a dimention table called fixed Cost having [Equipment N] and [Fix Cost] columns I have a measure Equipment KMS = CALCULATE(SUM('Prototype Modeling_Freight'[Loaded Distance]) + SUM('Prototype Modeling_Freight'[Deadhead Distance])) Shown as a table visualization Through a relationship connection between Equipment and Equipment N MY REQUIREMENT : A measure defined for each equipment as [Fix cost] / [Equiment KMS] TIA
