Divide function isnt working correctly
Hello! I'm having a very simple issue but seems to be causing me issues than it should but I am doing a simple divide dax function however the numbers being returned are not correct. I've tried opening a completely new document and trying the divide function there, thinking it might be a filter, but still getting all the wrong numbers in the column. The formula is HitRate = Divide(CRM_DBMarketingRolling12mthsBaseStatsDetailed[Won], CRM_DBMarketingRolling12mthsBaseStatsDetailed[Won]+CRM_DBMarketingRolling12mthsBaseStatsDetailed[Lost], 0) It is a calculated column. Can someone help, please? Thank you
Table Filter not working when using measure
Hi everyone, when I am using the following measure: LM Change = SWITCH( TRUE(), ISBLANK([LM CY]) && ISBLANK([LM PY]), blank(), DIVIDE( [LM CY], [LM PY], "" )-1 ) I get the following table that outlines last month sales of the current year, it's corresponding sales in the previous year and the percentage change between these two figures per account: However, when I would like to split each account sales by country by dragging it in the rows-section of the visual, it says Can anyone please help me understand and solve this error? Thank you in advance!
Divide all categories by one category-total
Hello all, If anyone can help me it is much appreciated. I have a financial report were I divide the differend revenues by the total revenue. This is working. But now I like to divide the costs also by the total revenue. I first made a formula for the total Revenue. Kosten%4 = CALCULATE(SUM(GeneralLedgerBalances[AmountDC]), 'Volgorde'[Rapportage omschrijving] = "Omzet verpakken", ALLSELECTED('Rapportage_Grootboek'[oms25_0], 'Rapportage_Grootboek'[reknr])) (I added 'Rapportage_Grootboek'[reknr]), because 'Rapportage_Grootboek'[oms25_0] is sorted by Rapportage_Grootboek'[reknr])) After this I first tested if I got the right percentages of the revenue, and this was working. Kosten%1 = VAR Omzetverpakken = CALCULATE(SUM(GeneralLedgerBalances[AmountDC]), 'Volgorde'[Rapportage omschrijving] = "Omzet verpakken", ALLSELECTED('Rapportage_Grootboek'[oms25_0], 'Rapportage_Grootboek'[reknr])) RETURN DIVIDE( CALCULATE(SUM(GeneralLedgerBalances[AmountDC]), ALL(Volgorde[Rapportage omschrijving]), ('Volgorde'[Rapportage omschrijving]) = "Omzet verpakken") , Omzetverpakken ,0) Now I thought it was simple to get all the percentages by replacing the "Numerator" in: Kosten%2 = VAR Omzetverpakken = CALCULATE(SUM('GeneralLedgerBalances'[AmountDC]), 'Volgorde'[Rapportage omschrijving] = "Omzet verpakken", ALLSELECTED('Rapportage_Grootboek'[oms25_0], 'Rapportage_Grootboek'[reknr])) RETURN Divide( SUM('GeneralLedgerBalances'[AmountDC]), Omzetverpakken, 0) For the revenue it is still working, but for the other categories not. I get only zero's because of the alternate result. So, I deleted the Divide functions and made the following formula: Kosten%7 = VAR Omzetverpakken = CALCULATE(SUM('GeneralLedgerBalances'[AmountDC]), 'Volgorde'[Rapportage omschrijving] = "Omzet verpakken", ALLSELECTED('Rapportage_Grootboek'[oms25_0], 'Rapportage_Grootboek'[reknr]), VALUES(Volgorde[Rapportage omschrijving]) ) RETURN SUM('GeneralLedgerBalances'[AmountDC]) / Omzetverpakken For the revenue this is still working, but now I get a message for the other categories. See the results below. By the way, the percentage of the Total 0,23 is shown and is correct. I have search a lot of time to solve this problem, but I overlook something. And I hoop that one of you can help me with this. Thank you in advance!Help with Formula for Days in AR
Hello! Good Afternoon. I am needing some help with a formula for showing casing the # of Days in AR. Below you will find all the formulas I used inside of my report. I also have provided several screenshots. I am not sure what I am doing wrong. Please help!!!! My teammates are getting frustrated with me. 😞 I can't figure it out. Thank you so much in advance! Sincerely, Amanda Last 6 Month Charges = 1,689,901.39 How I got the Last 6 Month Charges is by using the Date (relative date) filter. I also had a formula called IsLatest ..that is a True / False statement set up to only sum charges by latest modified date so it wouldn't be adding up duplicate values. Count of Days in Last 6 Months = 184 I used my Calendar Table and chose the column “Days in Month.” I then used the Date Filter to only count the days in the last 6 months. Average Charges in Last 6 Months = 8,966.86 I then set up a measure to calculate the Average Charges by dividing the Last 6 months charges by the # number of days in last 6 months. I also applied the date filter for the last 6 months. DAX FORMULA USED: Avg Charges = DIVIDE([Last 6 month Charges], COUNT(_Calendar[Days in Month]),0) Total AR = 593,560.15 I just used my Charges Table and Chose "Balance" Total AR Days = 66 ($ 59, 3560.15 Total AR / $ 8,966.86 Average Charge in last 6 months) *****When setting up this formula I get the following value = 45 Using dax formula = AR Days = DIVIDE([Total Balance],[Avg Charges], 0)DAX Divide function
I want to divide, Count(items.length) / workingDays. { Count(item.length) = count of different product, and Working days = No. of days betwwen two selected dates } for that I wrote DAX function Measure 4 = DIVIDE(CALCULATE(COUNT('Production of the day'[productshortname])),VALUES('Production of the day'[actualendtime])) but it doesn't show any result. I even make separete measure for Count and Values of working days and divide these measure by making another masure. but it didn't work. What is going wrong.? How should i make it correct.?
