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, 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!

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

Hi, Aucesar 

 

What is the correct total value you expect?

 

Best Regards

  • Aucesar's avatar
    Aucesar
    Icon for Helper III rankHelper III
    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.