A function "PlaceHolder" has been used in a true/False expression that is used as a table filter .
Hi There, I am trying to create one measure where i am tryin to get Sum of Session Duration for Distinct Session Id's for each process name . in SQL we can do like this : Select Session Id , Sum (Session Duration) From XYZ Table where Process Name="X" Group By Session ID However when i am trying to replicate same logic in DAX i am getting below mentioned error : Session_Disticnt Count is a measure which i have created to get Distinct Values of session id's Request anyone to help in solving this issue . Thanks, Ash amitchandak Ashish_Mathur
Replicating Minifs date in power bi
Im trying to create a measure that will enable me to generate the "Sales order date for return" columns available: key(which is the customer&order item), sales order date & return order date in excel, sales order date for return = MINIFS(B:B,A:A,A2,B:B,">="&(C2-15)) Thanks!How to make RANKX function rank based only on the first row group and exclude the other row groups
Hi, I have a rank function that needs to be calculated based only on Column1. Even if I add two or three other columns, the ranking should always be based on Column1. How can I ensure that my DAX formula ignores all columns except Column1 for ranking ? Note: Column1, Column2, and Column3 are from different dimension tables. MEASURE : RANK = VAR COLUMN1 = FILTER( ALL(D_COLUMN1_TABLE), CALCULATE( SUM(F_SCORE[SCORE]) ALL(D_COLUMN2_TABLE) ) <> 0 ) RETURN RANKX( COLUMN1, CALCULATE(MAX(D_COLUMN1_TABLE[NAME])) , , ASC, Dense ) This is the result i got:
