grand total in table visual is not summing values correctly
Hello, i have a measure where i need to multiply a percentage column with another measure . in the row level the output is correct but tabel grand total is wrong new achiev measure= [overall achiev]*MIN('Agent Rate Key'[Agent Rate]) i was trying to use summarize with the columns mentioned in the table but still it's not working
Rating system not giving me a total
I'm looking to create a rating system that will display the overall health of a division example; anything greater than 80% is 1 point, 50% - 79% will be .5 points, 49% and less is 0 points. i created the following dax which was able to give me the correct values, but i was not able to get the table to calculate a total, its giving me an average Overall point = VAR _Claims = SWITCH( TRUE(), [% of Claims Assigned] >= .80, 1, [% of Claims Assigned] >= .60 , .5, 0 ) VAR _Risk = SWITCH( TRUE(), [% of Risk Assigned] >= .80, 1, [% of Risk Assigned] >= .60 , .5, 0 ) VAR _Casualty = SWITCH( TRUE(), [% of Casualty Assigned] >= .80, 1, [% of Casualty Assigned] >= .60 , .5, 0 ) VAR _Property = SWITCH( TRUE(), [% of Property Assigned] >= .80, 1, [% of Property Assigned] >= .60 , .5, 0 ) VAR _Primary = SWITCH( TRUE(), [% of Primary Assigned] >= .80, 1, [% of Primary Assigned] >= .60 , .5, 0 ) VAR _Cyber = SWITCH( TRUE(), [% of Cyber Assigned] >= .80, 1, [% of Cyber Assigned] >= .60 , .5, 0 ) VAR _Total = CALCULATE(_Claims + _Risk + _Casualty + _Property + _Primary +_Cyber) RETURN _Claims + _Risk + _Casualty + _Property + _Primary +_Cyber Expected visual the total is 32.5 current visual is giving an averagemeasure is returing wrong total value in table visual
hi everyone i have created a measure that calculates the sales agents incentive. it's returning value per row correct but the total value in the table visual is wrong the measure is : new agent incentive = CALCULATE([new commissin sum]*max('Agent Rate Key'[Agent Rate])) new commission sum measure : new commissin sum = Sumx(Summarize('categories trans','categories trans'[categories summarize],'categories trans'[base type without zeed], "_1", [new commission calculation]), [_1]) new commission calculation measure : new commission calculation = IF([new achiev %]<= 0.8999,0, IF(([new achiev %]>=.90 &&[new achiev %]<=.9499),300-(.1*300), IF([new achiev %]>=.95 &&[new achiev %]<=.9999,300-(.05*300), IF([new achiev %]>=1 &&[new achiev %]<=1.09,300, IF([new achiev %]>= 1.1 &&[new achiev %]<=1.1999,300+(.1*300), IF([new achiev %]>=1.2 &&[new achiev %]<=1.29999,300+(.2*300),IF([new achiev %]>=1.3,300+(.3*300),0)))))))HELP WITH SUM FORMULA
I need urgent help on a SUM formula please! I am trying to make a matrix table which sums up a number for the entire year, even when the table shows quarterly periods. For example, there is $5k of sales to renew across the whole of 2022, with differing amounts per quarter. I would like the output of my formula to show $5k for each of the quarters and not their individual portfolio . I have added the formula below which I thought should work. I have added a summary of the data below, thanks in advance!
Help with DAX
Hi All, Hope you are all safe and well. Just want some help with a DAX please as follows. I'm creating a dashboard with lead start date from Leads entity and want total distinct customers from Customers table to be displayed who have start date >= Opportunity close date. Also, want to get purchase amount total for the customers to be available as well. So, based on the lead start date filter, the respective opportunities who are having link to Account which is connected to customers through service table needs to be displayed. The relationship from power bi model is as follows. Hope to hear from you. Regards Sanj
Summing calculated column based on IF condition
Hi, I have two data sets merged into 1 by a join. in data set A I have complete data for forecast at volume and value level. in data set B I only have the volumes only which are available for sales. Sample data set: I need to calculate the value of the constraint Forecast in value based on following: - Blanks means the volume and value are same as the unconstraint forecast. - Value is calculated by dividing value by volume for each SKU. (i m using sumx formula to calculate the value for each line) For instance for SKU 4, the constraint value is 6000. And total constraint value across all SKUs is 187,600 I am getting following result when I view it SKU-wise. However, at the total level its not summing up unconstrained + constrained forecast value and just giving a sum of constrained value. (not based on sample above) Would really appreciate if someone can help me out on calculating the correct total constraint value!
