Trying to add dax to calculate all filters besied one.
Hi Guys, I have used this dax on my fct_table: % of Instance Total Cost Test = DIVIDE( Sum(Fct_EA_AmortizedCosts[CostInBillingCurrency]), CALCULATE( SUM(Fct_EA_AmortizedCosts[CostInBillingCurrency]), Fct_EA_AmortizedCosts[PricingModel] = "OnDemand" ) ) Page Filter is also "OnDemand". But it is always returning 100%... Why? Generally i want to divide row filter context in table by sum of all this rows: but it is somehow giving 1,00 (100 %)... Can anybody help ? Goal: Keep filter context in table and always take current row sum of costs and divide by total row created from filter context... why this is not working what i did? Best, Jacek
Total Overall Value and Individual Value using the same Measure. How to divide them
Hi All. I'm kind of stuck here. Need your help on this. My problem is the measure used to get defect count and total defect count is the same, to differentiate it is using Plant (a column). I want to calculate defect count weightage as per formula below: Defect count weightage = defect count / total defect count The total defect count is the row that I highlighted in the screenshot. How to get that value if it's using the same measure? Here is the measure used to calculate the defect count. DefectCount = SUMX(FILTER(Joined_FactAIVC,Joined_FactAIVC[DefectClass]<> "Produced Glove" && Joined_FactAIVC[DefectClass]<> "Good Glove" && Joined_FactAIVC[DefectClass]<> "Empty Link" && Joined_FactAIVC[DefectClass]<> "System Status"),[Value]) Kindly help.
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 youCalculate % of hours worked base two different working schedual using a calculated table/measure
Hello Power BI community, I will need some help for this task. I have two working schedule, the first one include working on saturday for 8 hours whereas the second one only works for 5 hours on that day. I created a calculated column to have a full calendar (removing the sundays) and specify the number of hours per day : The total number of hours worked and the names are on a non calculated table. The objective is to calculate depending on the person the % of hours worked (filtred by the number of days) In short : I want to devide "number of hours worked" by "sum work hour normal/exception" depending on the person. Thank you for your time and help!Divide Dax Formula by category
Hi everyone, I wish to have a visual card of the information which has been circled in red at the end of the image. I am trying to obtain the "total Project Average" which can be seen in the bottom of the first image to display this info on a card visual. The column "Actual Weighted Completion" is calculated by multiplying the columns of "Completion" and "Weighted Task" together. This total project average is calculated by summing the "Actual Weighted Completion" according to the respective project (e.g. Assignment 1). So the summation of the "Actual Weighted Completion" for assignment 1 is 56%, for assignment 2 is 0% and for assignment 3 is 100%. Hence getting the average of these 3, you get the value of the "Total Project Average" of 52%. If you divide (to get the average) only the "Actual Weighted Completion" column you get the result of 10%, which is not the result I wish to obtain. Was wondering if I could get some assistance on this and help me out. Thank you in advance.
New calculated column
Hello, I would like to ask for a help with this specific problem. I need a calculated column that would take SUM of Amount from different product categories and divide them by number 30. After that I would like that number to be divided by the "Bed Count" which is a column in a different table. I have tried multiple DAX formulas but nothing seems to do the trick in the way I realy need. Any help would be masively appreciated. MatejAverage Working Days Divided by two for Part Time Employees
Good Day, I am needing to adjust my Dax formula to divide by two when the employee is Kennedee Lantis. Can someone lend me a hand? Per Day Average = CALCULATE(Audit[SUM pro/job Audits & Entries]/MAX('Working Days'[Working Days]) + 0) Many thanks, Lydia
