Forum Discussion

andicornejo12's avatar
andicornejo12
Helper II
2 years ago
Solved

Row Count Sum

Hello Community,   I am stuck here. The request is to have a 1 in every row of a table built in the report, but the sum gives the total of those rows. For showing the "1" everywhere, I added a cus...
@Dax help
  • talespin's avatar
    talespin
    2 years ago

    hi andicornejo12 ,

     

    Please use this measure, replace it with your column. If there are other columns in your visual, might need to modify measure. Ignore the custom column in second screenshot(not required).

     

    MCount =
    IF(HASONEFILTER( TestTbl4[AWBNo] ), 1, COUNT( TestTbl4[AWBNo] ) )
     
     

     

     

andicornejo12's avatar
andicornejo12
Helper II
2 years ago

hi Dangar332 

 

Thanks for your reply. I already tried distinctcount. The problem with this, is the second column of my table above. It doesnt give me the total, the total is shown as 1 as well 😞

Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

hi, andicornejo12 

try below measure

countofid = IF(ISINSCOPE('Table'[id]),1,SUM('Table'[value]))

 

  • andicornejo12's avatar
    andicornejo12
    Helper II
    2 years ago

    hi Dangar332 

     

    This is almost perfect.!!! However only works with AWB Number if I substitute AWB number column with AWB version it doesnt work anymore :(.

    Is there a way to use this formula to build a table from any column ?? see below first image is AWB number and is perfect, second image though is AWB version instead of AWB number and it doesnt work anymore. I need to have the AWB number in the table

     

     

    • Dangar332's avatar
      Dangar332
      Resident Rockstar
      2 years ago

      hi, andicornejo12 

      not sure but just try 

      nested if 

      countofid = IF(
          ISINSCOPE('Table'[awb number]),
          1,
          IF(
            ISINSCOPE('Table'[awb vers no]),
            1,sum('Table'[awb vers no])
          )
          )