Calculated Measure and Percentage is changing when used slicer and filter
Team, Good day, I am trying to calculate the percentage value for the categories against the total value. DAX formula is working fine but when slicer or filter values are filtered the outpwut is not chnaging and showing as it is. I am using below DAX function DIVIDE(SUM(RPT_CARBON_UNPIVOT[Value]),CALCULATE(SUM(RPT_CARBON_UNPIVOT[Value]),ALL()) ) Kindly help me on this on DAX function for any kind of slicer and filter thanks M. Vijay Antony
DAX Error: A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table
Hi, I am new to DAX. I have an assignment which requires me to convert all 3 steps tables to only one table using CALCULATETABLE function. When i tried to do for the first 2 steps, there is an error shown as below. Hereby I attach the 3 steps table for your reference: Table1: forecasting_uoa_payroll_step1 = FILTER ( uoa_payslips_history_aggregated, DATEDIFF(uoa_payslips_history_aggregated[YearMonth],TODAY(),MONTH)<variable_uoa_per_cust_window[Variable_UoA_per_Cust_Window Value]+1 ) Table 2: forecasting_uoa_payroll_step2 = SUMMARIZE ( forecasting_uoa_payroll_step1, forecasting_uoa_payroll_step1[Country], "UoA Per Customer Average", AVERAGE(forecasting_uoa_payroll_step1[UoA_per_Customer]) ) Table 3: forecasting_uoa_payroll_step3 = SELECTCOLUMNS ( customer_payroll_forecast, "Date", customer_payroll_forecast[YearMonth], "Country", customer_payroll_forecast[Country], "Customers", customer_payroll_forecast[Total Headcount] ) Thank youTotal Sum in each row in a table issue of DAX
Hello Everyone, I am facing an issue , and unable to solve. I have this below data. I want 14968 Value for all the voice numbers under "Total Invoice Amount" similar to "Total test Value" column. I have achieved the Total test Value using a calculated column using Earlier fuction, But its not changing dynamically with slicer selection. With slicer selection the value should be 14968. Here Invoice Item Amount Measure2 is a Measure. The Total Invoice Amount should be "sum of allthe invoice item amount measure 2 grouped by voice number." I have written the below formulas: Invoice Item Amount Measure 2 is a Measure, Invoice Item Amount Measure 2 = SUMX( 'Invoice Hold Facts', IF( 'Invoice Hold Facts'[Highest Ranking Indicator] = "Y", 'Invoice Hold Facts'[Invoice Item Amount], 0 ) ) Total test Value is a Calculated column using Invoice Item Amount Measure 2 Total test Value = CALCULATE( [Invoice Item Amount Measure 2], FILTER('Invoice Hold Facts','Invoice Hold Facts'[Invoice Number] = EARLIER('Invoice Hold Facts'[Invoice Number]) && 'Invoice Hold Facts'[SUPPLIER_WID] = EARLIER('Invoice Hold Facts'[SUPPLIER_WID]) && 'Invoice Hold Facts'[Highest Ranking Indicator] = "Y")) ------------------------------------------------------------------------------------------------------ I have tried other methods as measures , but nothing is working. Below are some methods I tried i have commented some methods in it. Total Amount Measure = /*CALCULATE( SUM('Invoice Hold Facts'[Invoice Item Amount]), FILTER( 'Invoice Hold Facts', [Invoice Item Amount Measure] = CALCULATE( SUM('Invoice Hold Facts'[Invoice Item Amount]), 'Invoice Hold Facts'[Highest Ranking Indicator] = "Y" ) ) )*/ /*SUMX( SUMMARIZE( 'Invoice Hold Facts', 'Invoice Hold Facts'[Internal Invoice Id], "TotalInvoiceAmount", [Invoice Item Amount Measure 2] ), [TotalInvoiceAmount] )*/ /*SUMX( VALUES('Invoice Hold Facts'[Invoice Number]), [Invoice Item Amount Measure 2] )*/ /*CALCULATE( SUM('Invoice Hold Facts'[Invoice Item Amount]), ALLEXCEPT('Invoice Hold Facts', 'Invoice Hold Facts'[Invoice number]) )*/ SUMX( VALUES('Invoice Hold Facts'[Invoice Number]), CALCULATE( SUM('Invoice Hold Facts'[Invoice Item Amount]) ) ) PLEASE HELP. THANKYOUSame period previous N months
I want to calculate total sales for previous N months for the same period according to the slicer. Eg if in slicer I select range from 1-10-21 to 3-10-21 the my column chart should display total sales for previous N months within this range. I wrote following Dax measure for the same but not getting desired result: same period = CALCULATE(SUM(financials[ Sales]),DATESINPERIOD('Date'[Date],MAX('Date'[Date]), -'Select N'[N Value],MONTH),FILTER(financials,AND(financials[Date]>=MIN('Date'[Date]),financials[Date]<=MAX('Date'[Date])))) Any suggestions are apprecited.
Power BI Dax to calculate sum of quantity based on the two date time fields.
Hello All, I would like to seek help in calculating the sum of quantity based on the below condition. I’ve “created date” as data time field used in advanced filter pane with option to select the date and time format as shown below. Date Time selected in the example is (09/05/2023 11:00 PM to 09/18/2023 11:00 PM). User has the ability to change the date time selection using the advanced filtering. Need to calculate the sum of quantity only when the “Changed date” (Date Time format) is greater than the max of “Created Date” (Date Time Format) field selected using the advanced filter option. Sum of quantity will be calculated only when the “Changed Date” is greater than max of “Created Date” (09/18/2023 11:00 PM). “Created Date” will be dynamically changed based on the selected using Advanced Filtering. Need to get the max of created date time I’ve provided data and expected output for the condition mentioned above. Also, Attached the screenshot of the data. Highlighted in yellow are the data matches the condition. I would appreciate any help on the same. Thank you! Data ID State Created Date Changed Date Quantity 1160 NY 09/05/2023 11:30:00 AM 10 1161 NY 09/05/2023 4:00:00 AM 09/08/2023 10:00:00 PM 20 1162 NY 09/06/2023 8:00:00 AM 09/19/2023 4:00:00 PM 20 1163 NY 09/06/2023 7:00:00 PM 09/10/2023 6:00:00 AM 60 1164 NY 09/08/2023 10:00:00 PM 09/20/2023 11:00:00 AM 60 1165 NY 09/10/2023 6:00:00 AM 09/21/2023 4:00:00 PM 80 1166 NY 09/17/2023 9:00:00 PM 50 1167 NY 09/17/2023 11:30:00 PM 30 1168 NY 09/22/2023 2:00:00 PM 35 1169 CA 09/05/2023 11:30:00 AM 10 1170 CA 09/05/2023 4:00:00 AM 09/08/2023 10:00:00 PM 100 1171 CA 09/06/2023 8:00:00 AM 09/19/2023 4:00:00 PM 150 1172 CA 09/06/2023 7:00:00 PM 09/10/2023 6:00:00 AM 180 1173 CA 09/08/2023 10:00:00 PM 09/20/2023 11:00:00 AM 200 1174 CA 09/10/2023 6:00:00 AM 09/21/2023 4:00:00 PM 300 1175 CA 09/17/2023 9:00:00 PM 50 1176 CA 09/17/2023 11:30:00 PM 30 1177 CA 09/18/2023 2:00:00 PM 35 1178 CA 09/05/2023 11:30:00 AM 10 1179 TX 09/05/2023 4:00:00 AM 09/08/2023 10:00:00 PM 135 1180 TX 09/06/2023 8:00:00 AM 09/19/2023 4:00:00 PM 142 1181 TX 09/06/2023 7:00:00 PM 09/10/2023 6:00:00 AM 155 1182 TX 09/08/2023 10:00:00 PM 09/20/2023 11:00:00 AM 165 1183 TX 09/10/2023 6:00:00 AM 09/21/2023 4:00:00 PM 175 1184 TX 09/17/2023 9:00:00 PM 50 1185 TX 09/17/2023 11:30:00 PM 30 1186 TX 09/18/2023 2:00:00 PM 35 1187 TX 09/23/2023 11:30:00 PM 40 1188 TX 09/23/2023 2:00:00 PM 40 Expected Output State Quantity NY 160 CA 650 TX 482 Snapshot of Data. Highlighted in yellow are the data matches the condition mentioned above.
