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.

     

     

     

     

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.

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.