single measure select multiple value shows in one graph
how to show three different values in one graph Redution buckts Ex Rate New Materials scrap values 0.7 0.17 0.45 0.7 0.27 0.35 0.7 0.17 0.45 Valueof Month Values Dec 2020 120 -> starting inventory Jan 121 feb 111 March 121 --> end inventory Graph should like below any idea . thanks in advance
DAX in building Rolling 4 Week Average
Hi, I need help in building 4 week rolling average for "Net Change in Price and Cost" with below sample data Change in Price, Change in Cost and Net Change in Price and Cost are all 3 measures. Net Change in Price and Cost = Change in Price - Change in Cost I do have separate date table and the above data shows weekly data and my report has Invoice Date as Filter. I need to calculate rolling 4 week average, here the tweak is that for first week start date 12/07 rolling average should be same while for next 12/14 it should (-4.80% + 0.18%)/2 = -2.31% for 12/21 it should be (-4.80% + 0.18% - 0.04%)/3 = -1.55% for 12/28 it should be (-4.80% + 0.18% - 0.04% -0.65%)/4 = -1.33% for 01/04 it should be (0.18% - 0.04% -0.65% +1.03%)/4 = 0.13% as shown below I have created below DAX but its not working as expected Net Change in Price and Cost 4 Wk Rolling Avg = var start_day = MIN('Date'[Week Start Date])-21 var end_day = MAX('Date'[Week Start Date]) return CALCULATE([Net Change in Price and Cost], DATESBETWEEN('Date'[Week Start Date],start_day,end_day), REMOVEFILTERS('Date'[Week Start Date]))/CALCULATE(DISTINCTCOUNT('Date'[Week Start Date]),DATESBETWEEN('Date'[Week Start Date],start_day,end_day),REMOVEFILTERS('Date'[Week Start Date])) Can someone help me on this??
How to remove Scientific Notation
In my table data looks like Scientific Notation.please find the screen shot. i have used below measure for the graph Total Month = IF(SELECTEDVALUE('Order Table Total'[Sno])="6.Total Month Variation",CALCULATE(SUM('Master Data Base'[Value]),ALLSELECTED('Order Table Total'[Sno])), SUM('Master Data Base'[Value])) how to trun off scientif notation in my report . i am trying to Format i am getting Error. Looking for support.
SUMX Different Column Depending On IF Condition
Hello All, I am struggling with a measure that is trying to accomplish the following: I have a set of ID_Tasks attributed to ID_Project and I want to find the TotalSales by summing either TotalSalesSingle or TotalSalesMulti depending on if my dynamic selection (slicer on ID_Task) contains duplicate ID_Project or not. I have a first measure that checks if my selection contains duplicates or not, and counts them. Duplicates = CALCULATE(COUNT(SalesProfiles[ID_Project]), ALLSELECTED(SalesProfiles), VALUES(SalesProfiles[ID_Project])) Basically, I am looking for the following results: 1. If I select 2 ID_Task that are from different ID_Project, I want to sum the TotalSalesSingle value for each. 2. If I select 2 ID_Task that are from a shared ID_Project, I want to sum the TotalSalesMulti value for each. 3. If I select all 3 ID_Task , 2 of which share a ID_Project, and 1 does not; I want to sum the TotalSalesMulti for the 2, and TotalSalesSingle for the 1. aka it will sum values from either TotalSalesSingle or Multi depending on Duplicates = 1 or != 1, evaluated for each row. Scenarios: Single Selection: ID_Project is unique value, returns TotalSalesSingle for Total Sales Multi Selection: ID_Project is non-unique value, returns TotalSalesMulti for TotalSales Here you can see that my measure TotalSales doesnt work. I'd like it to return 231 & 351 (TotalSalesMulti column) Multi Selection: All 3 selected. Doesn't work either. In this case I'd like it to return TotalSalesMulti (231 & 351) for ID_Project = 38515, and TotalSalesSingle (856) for ID_Project = 29677. This is my current measure for TotalSales which is far from working. Total Sales = SUMX ( ProjetList, IF( [Duplicates] = 1, SUMX ( SalesProfiles , SalesProfiles[TotalSalesSingle] ) , SUMX ( SalesProfiles , SalesProfiles[TotalSalesMulti] ) ) ) I've included the files below. https://1drv.ms/f/s!AndVpJp2VQectSrHRNEZnOIC2Kqj?e=CA0QS6 Please let me know what you think, and if I wasn't clear about anything. Thank you!
Need help quick! Percent On Time measure not working with filters?
I have a whole page dedicated to exploring our products that have shipped late, meaning there is a page filter for [On Time Ship]="False". I also have a measure to calculate the % on time for each product. The formula is: % On Time = CALCULATE(DISTINCTCOUNT(CVD_OTD_FTMS_IV[Reference Number]),CVD_OTD_FTMS_IV[On Time Ship]=true(),REMOVEFILTERS(CVD_OTD_FTMS_IV[On Time Ship]))/CALCULATE(DISTINCTCOUNT(CVD_OTD_FTMS_IV[Reference Number]),REMOVEFILTERS(CVD_OTD_FTMS_IV[On Time Ship]))​ where [Reference Number] is the unique identifier for someone's ordered item. This measure isn't working the way I want it to and I am not sure why. The count of late items works as expected, but the total count (or denominator in my % on time measure) doesn't show what I expect unless I remove the page filter for [On Time Ship]="False". I don't know why this would be the case since I have a RemoveFilters command in the measure formula?? For example, the product below shows this with the page filter applied: and the same product without the page filter applied: The real total count is 277 for this product. Why is it only 55 when the page filter is applied?? I need help rather quickly, please and thank you!!
