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] ) )
     
     

     

     

talespin's avatar
talespin
Solution Sage
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 talespin 

 

Thanks again for your help.

Your formula almost works is showing a one and the total.

However, the request is a bit more complicated, in my example I used AWB Number but the request is that row count should work with any column in the table. See with AWB version below, is not working anymore (your solution is RowCount1 in red)