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.

     

     

     

     

Semaj06's avatar
Semaj06
Regular Visitor
3 years ago

Hi

 

You cannot use it as a measure, you are returning 2 columns and with a measure you have to return only 1 value.

If you want to claculate, just do a measure with the countrows part and just publist the shift colum on the display and your new measure.