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
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.