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