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 Community,
I could create a table with this:
NewTable = SUMMARIZE(tableA, TableA[Shift1], "NewColunm", DISTINCTCOUNT(TableA[ProductionBtach]))
Everithing good, but when I tried to use as Measure, I got "multiple columns cannot be converted to a scalar value". So my question is how to transform DAX above to be used as measure? both colunms are text.
Solved! Go to Solution.
Hi @v-zhangti I forgot to close this topic I figured out using another method, in my calculation I did the "removefilters" and it worked as expected. Thanks for your time, this the expected result.
Hi
You cannot use it as a measure, you are returning 2 columns and with a measure you have to return only 1 value.
If you want to claculate, just do a measure with the countrows part and just publist the shift colum on the display and your new measure.
Hi @vicky_ sorry, didn´t put any date, basically as below:
Shift1 | Shift2 | Desire Result | ||
ProductionBatch | Worker | Worker2 | Employee | ProductionBatch-Worked |
A1 | Lois | Reggie | Lois | 2 |
A1 | Lois | Reggie | Reggie | 3 |
A1 | Reggie | Lois | Dannie | 2 |
A1 | Dannie | Lois | ||
B1 | Lois | Reggie | ||
B1 | Reggie | Lois | ||
B1 | Reggie | Lois | ||
C1 | Reggie | Dannie | A1 | |
C1 | Dannie | Reggie | ||
C1 | Reggie | Dannie | ||
C1 | Dannie | Reggie | ||
A1 | Lois | Reggie | ||
A1 | Lois | Reggie | ||
A1 | Reggie | Lois | ||
A1 | Dannie | Lois | ||
B1 | Lois | Reggie | ||
B1 | Reggie | Lois | ||
B1 | Reggie | Lois | ||
C1 | Reggie | Dannie | ||
C1 | Dannie | Reggie | ||
C1 | Reggie | Dannie | ||
C1 | Dannie | Reggie |
Hi, @Aucesar
You can try the following methods.
Measure = Var _table=SUMMARIZE(TableA, TableA[Worker], "NewColunm", DISTINCTCOUNT(TableA[ProductionBatch]))
Return
MAXX(_table,[NewColunm])
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-zhangti put sample data, with comments, if you could take a look, your data sample and example, worked for colum Worker1 but when I use on worker2 in the real data, doesn´t worked as expected;
Give a try when possible;
https://1drv.ms/u/s!AktM4_8VYySOiJMb5iee9iC3tU0cpA?e=3Okqh1
Hi, @Aucesar
You can try the following methods.
Measure 1 = Var _table=SUMMARIZE(Refugo, Refugo[Ajudante],Refugo[Numero Fusao], "NFusoesAjudante", DISTINCTCOUNT(Refugo[Numero Fusao]))
Return
SUMX(_table,[NFusoesAjudante])
Measure 2 = Var _table= SUMMARIZE(Refugo, Refugo[Moldador],Refugo[Numero Fusao], "NFusoesMoldador", DISTINCTCOUNT(Refugo[Numero Fusao]))
Return
SUMX(_table,[NFusoesMoldador])
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @v-zhangti not yet, if I do the sum from both measure values are not correct;
Also as the real data is available now, we could try using Refugo Table which is the main table, fell free , any help is welcome!
Hi @v-zhangti I forgot to close this topic I figured out using another method, in my calculation I did the "removefilters" and it worked as expected. Thanks for your time, this the expected result.
Like you said, you're creating a table with that DAX function you've written.
If you need it to display as a measure in a table, you need to tell powerBI how to summarize the table to return only 1 value. Without more specifics, it's hard to tell you how to summarize it, but you can use functions such as MAX, COUNT, etc.
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 |
---|---|
96 | |
94 | |
82 | |
70 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |