Forum Discussion

Aucesar's avatar
Aucesar
Icon for Helper III rankHelper III
3 years ago
Solved

Scalar Value, dealing with text convert DAX Table to Measure

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 ...
Need Help
  • Aucesar's avatar
    Aucesar
    3 years ago

    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.

     

     

     

     

Aucesar's avatar
Aucesar
Icon for Helper III rankHelper III
3 years ago

Hi vicky_ sorry, didn´t put any date, basically as below:

 Shift1Shift2Desire Result
ProductionBatchWorkerWorker2EmployeeProductionBatch-Worked
A1LoisReggieLois2
A1LoisReggieReggie3
A1ReggieLoisDannie2
A1DannieLois  
B1LoisReggie  
B1ReggieLois  
B1ReggieLois  
C1ReggieDannie A1
C1DannieReggie  
C1ReggieDannie  
C1DannieReggie  
A1LoisReggie  
A1LoisReggie  
A1ReggieLois  
A1DannieLois  
B1LoisReggie  
B1ReggieLois  
B1ReggieLois  
C1ReggieDannie  
C1DannieReggie  
C1ReggieDannie  
C1DannieReggie  
  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    3 years ago

    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.

      • v-zhangti's avatar
        v-zhangti
        Icon for Community Support rankCommunity Support
        3 years ago

        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.