#Error when using Sum() function in paginated report
When ever I am trying to sum a column, instead of getting a number if get #error. The column is filled with currency values. There are some cells that are blank so that could be the issue. Here are some things I have tried: =SUM(IIf(IsNothing(Fields!External_20_Review_Fee.Value),0,Fields!External_20_Review_Fee.Value)) =SUM(Fields!External_20_Review_Fee.Value) =SUM(IIf(INT(Fields!External_20_Review_Fee.Value),0,INT(Fields!External_20_Review_Fee.Value))
How do I create a measure to sum (total) up a distinct count?
Hi guys, As you can see in the picture down below I created a table with different colums: First column [VullingTotaalPerc] shows the percentage of version ID that are filled 100% and so on Second column [Count of Versies.Id] shows the count (distinct) of the total version ID. Third column [TotalVersiesIDCalculate] is a measure that I created that shows the count (distinct) of the total version ID but only for department X. Measure = TotalVersiesidCalculate = calculate(DISTINCTCOUNT(MKA[Versies.Id]),MKA[ProductieAfdeling]="COC2 en I&V") Fourth column [DistinccountVersies.id-Calculated] is a measure that I created that show the count (distinct) of versies.ID. DistinccountVersies.id-Calculated = DISTINCTCOUNT(MKA[Versies.Id]) Fifth column [COC2-Calculated] is a measure that I created - [TotalVersiesIDCalculate] divided by [DistinccountVersies.id-Calculated] to show what the percentage is of the total amount. The problem now is that when I use this formula: [TotalVersiesIDCalculate] / [DistinccountVersies.id-Calculated] the measure will divide 8 with 56 but what I want is that 8 will be divided by the total of 2533. Can anyone help me out here? Thnx!
Trying to get total sum of measure correctly
Hi, I need help in getting the correct values for the sum of a measure, the total showing wrongly. I have a measure that calculates the cost of consumption of electricity readings, the dax formula for cost is: Electricity = IF('Table'[Consumption]>10000,(('Table'[Consumption]-10000)*0.22+(6000*0.17)+(4000*0.13)),(IF('Table'[Consumption]<4000,('Table'[Consumption]*0.13),((4000*0.13)+('Table'[Consumption]*0.17))))) The Total should be 40308 When i tried to sum the measure using SUMX('Table','Table'[Electricty]) I tried to search online but couldn't; find a solution
Sales last year, same week number, same day
Hello there, I am currently having current year sales and have a measure calculating last year sales. However, it is looking on the same day last year increments but I am more interested in looking in the same week number, same day number (so if it is week 42, Monday, to look last year in week 42, Monday). I have managed to get the correct sales per day by creating a new collumn like this : DayWeekYear = ([UgedagNummer]*100+ [UgeNr])*10000+[År] and then a measure like this : Oms. kr. SÅ try = CALCULATE(SUM(F_Butikssalg[Oms]),FILTER(ALL(D_Periode),D_Periode[DayWeekYear] = MAX(D_Periode[DayWeekYear])-1)) BUT, this works only on a day level visual. If I want it displayed as a cummul of all values in a week or years and filter a longer period, it will not take all sales per specified period but rather print a value for one day. Oms is current sales. Oms. kr. SÅ is the current measure matching the same day last year (ex. 16 Oct with 16 Oct) and Oms. kr. SÅ try is last year sales taking into account week and day number( day number is : Monday=1; Tuesday=2.....Sunday=7) I want when selecting sales last year to have them dispayed looking on the same week number and day number on all levels of visualization and filtering: day/week/month/year. I have tried making the same column only with year&week but then I cannot get sales last year per day and if I create one visual and select multiple week, if i have weeks display I get correct amounts but not total and if i want only a total for filtered weeks i get again a wrong number. Majority of connection in the datamodel for date are made through D_Periode using Dato which is format as dd/mm/yyyy Thank you in advance.
