Forum Discussion
Helper IIIScalar Value, dealing with text convert DAX Table to Measure
Community SupportHi, 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.
Helper IIIHi 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
- v-zhangti
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.