Issue with Displaying All Days as Values from Calendar Table Using DAX Measure
Hi Everyone, I am facing an issue with the "Day" column from the calendar table. When using the following measure, only the day values are displayed from the column which as values from the fact table. However, I want all-day values to be shown from the column and I want the formula to show "zero" or leave the cell blank if there is no value for that day. Below is the measure I am using: DAX Formula: =DISTINCTCOUNT('_Orgination - Final_'[LoanId]) Note 1: There is a many-to-one relationship between the fact table and the calendar table, where the "many" side is the fact table and the "one" side is the calendar table. Note 2: The "Days[Row Label]" is from the calendar table. Note 3: I have tried several approaches but have not been able to achieve the desired result.
Subject: How do I show an independent value of a subtask (hierarchy) in a matrix ?
Hello, I am trying to create a matrix where the rows are a set of tasks that need to be completed. The tasks have subtasks. Both the tasks and the subtasks have statuses (that are independent of one another, i.e. task 1 (level 1) can be in progress, but a subtask can be completed). The statuses (icons) are the values in the matrix. However, I do not know how to set up the excel sheet and/or the hierarchy, to show these independent statuses. Most hierarchy examples I have seen only talk about numerical data, but this is non numerical. Statuses include: Not Started, In Progress, Completed, At Risk, Delayed. Below is the example of the matrix. Here, the main task can have a different status as compared to the subtask's status. I know that ISINSCOPE needs to be used but do not know how to exactly resolve the issue. Can someone please help me write this code to achieve the end result? Any help would be appreciated. Thank youDAX SWITCH FORMULA SHOWING INCORRECT GROUPING
Hi, I'm trying to create a DAX formula using switch. I need to group all negative numbers to display no_new_return|prev rtn. However, some negative numbers are falling into other groups designated for positive values. Example -41 is falling in other groups such as 0-21,22-30 etc. as highlighted in the below image. The formula works for numbers > 0 but the negatives are not being recognized. Any assistance is appreciated. formula : ORD_RCPT_TENURE_GROUP = SWITCH(TRUE(),'FF_ORDER_MST'[ORD_RCPT_TENURE]<0,"NO_NEW_RTN | PREV RTN",'FF_ORDER_MST'[ORD_RCPT_TENURE]>=0 && 'FF_ORDER_MST'[ORD_RCPT_TENURE]<=21,"0-21",'FF_ORDER_MST'[ORD_RCPT_TENURE]>21 && 'FF_ORDER_MST'[ORD_RCPT_TENURE]<=30,"22-30",'FF_ORDER_MST'[ORD_RCPT_TENURE]>30 && 'FF_ORDER_MST'[ORD_RCPT_TENURE]<=60,"31-60",'FF_ORDER_MST'[ORD_RCPT_TENURE]>60 && 'FF_ORDER_MST'[ORD_RCPT_TENURE]<=90,"61-90",'FF_ORDER_MST'[ORD_RCPT_TENURE]>90 && 'FF_ORDER_MST'[ORD_RCPT_TENURE]<=120,"91-120",'FF_ORDER_MST'[ORD_RCPT_TENURE]>120 && 'FF_ORDER_MST'[ORD_RCPT_TENURE]<=180,"121-180",'FF_ORDER_MST'[ORD_RCPT_TENURE]>180 && 'FF_ORDER_MST'[ORD_RCPT_TENURE]<=365,"181-365",'FF_ORDER_MST'[ORD_RCPT_TENURE]>365,"+365","NO_NEW_RTN | PREV RTN")Querying Tables using DAX from Mutiple Cubes
Hi All, We have Multidimensionsal solution with multiple cubes in Databse. We have setup linked server to database programtically query the data. Can some one please tell how to specify the Cube Name while querying the Table using DAX. We want to use same LinkedServer Connection to query data from Muliple Cubes Example: select * from openquery(LinkedServerName,''EVALUATE CubeName.Table'')) If we specify the Cube Name then it's not working . With MDX , we have option to specify the Cube Name ( From Clause) while with DAX we didn't find option. Please tell how to provide the Cube Name while querying from DAX Thanks, Abhiram
