Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
HI everyone,
I want to sum "Multiplicando" column. I tried to do the sum in the column "Sumando Multiplicando" but i failed.
I tried this measure:
I hope someone can help me.
Maybe try
measure= sumx(table([ID]),[multiplicando])
the table[ID] refers to whatever you are using to make the rows in your table. I guess it could be ('table'[NumSem]) or ('table'[AñoySem])
I tried that and appears :
No se puede determinar un valor único para la columna 'NumSem' en la tabla 'Combinar1'. Esto puede suceder cuando una fórmula de medida hace referencia a una columna que contiene muchos valores sin especificar una agregación, como min, max, count o sum, para obtener un resultado único.
Translated to english :
Cannot determine a unique value for column 'SemNum' in table 'Join1'. This can happen when a measure formula references a column that contains many values without specifying an aggregation, such as min, max, count, or sum, to get a single result.
Maybe take out the column name and just have
Measure = SUMX(Combinar1,[multiplicando])
iT gives a result but a wrong one.
The result was 0,25. But if you sum "Multiplicando" column manually we can see that is not true. The correct result should be 1,31. I have been trying some measures and all are given me the same incorrect result 0,25. Im going to try filtering first by a measure
My tries are:
Hi:
Can you share an example file? Thanks..
Im going to share a file as soon as i can.
Ty.
Hi:
That will be helpful, even if it's a few rows from each table involved. Thanks!
Here is a example file. The important sheet is "Tabla principal mejorada"
Can you see it?
Hi:
I still can not see it. Can you save it to google drive or dropbox and send it that way, as a link?
Thanks!
Bill
Remember that i want to create a measure that allows me to sum "Multiplicando" column. All columns to the right of "Multiplicando" column are tries that i did to sum that column, sadly my tries were unsuccesfull.
Thanks for helping me.
Hi:
If you are using measure as filter is a single visual you can try something like this(example):
Hello Gustavo:
I was able to open your file but there is no data in Table Medidas. I beleive you have a SUMX total issue. I will paste a couple of examples how to write the code for this type of problem.
Single Measure = SUM(_sUMxTABLE[amount]) -1000
Total Measure =
var vtable = SUMMARIZE(_sUMxTABLE,
_sUMxTABLE[ID],
"AMT", [single measure])
return
IF(HASONEVALUE(_sUMxTABLE[ID]),[Single Measure], SUMX(vtable,[AMT]))
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
So, if we have a measure like:
m_Single = SUM(Table1[Value])-50
This measure will cause problems in total lines. So, if we are summarizing by [Name], we create this measure:
m_Total 1 =
VAR __table = SUMMARIZE('Table1',[Name],"__value",[m_Single])
RETURN
IF(HASONEVALUE(Table1[Name]),[m_Single],SUMX(__table,[__value]))
If we are summarizing by [Category1], we create this measure:
m_Total 2 =
VAR __table = SUMMARIZE('Table1',[Category1],"__value",[m_Single])
RETURN
IF(HASONEVALUE(Table1[Category1]),[m_Single],SUMX(__table,[__value]))
NEXT EXAMPLE w SUMMARIZE:
sum Count of LINENUM =
SUMX (
SUMMARIZE (
LEM_STATUS_ALL_V,
LEM_STATUS_ALL_V[WAPPRDATE],
LEM_STATUS_ALL_V[WAPPRBY],
LEM_STATUS_ALL_V[SUBMITBY]
),
CALCULATE (
DISTINCTCOUNT ( 'LEM_STATUS_ALL_V'[LINENUM] ),
'LEM_STATUS_ALL_V'[LEMNUM]
)
)
I hope the language translates OK for you.
Thank you..
I tried the first option i didnt work.
The measure "Multiplicando" that i want to sum is this :
Remember the first to columns are not measures, everthing else are measures. Im going to still trying, ty vry much Whitewater100
Table "Medidas" is a table that i created to store my measure, is normal if you dont see columns.
Im going to read your answer, ty vry much.
Now i think will work
https://drive.google.com/file/d/1CJOCZs7VA-_dPH2pE30lYO3qnqGkeN3Y/view?usp=sharing
Hello:
What happens if you just do:
Sumando Multiplicando = SUM(TableName[Multiplicando])?
I forgot say that "Multiplicando" is a measure:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |