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)

 

 

  • talespin's avatar
    talespin
    Solution Sage
    2 years ago

    hi andicornejo12 ,

     

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

     

    Are the columns from same table or can be from different table?

     

    Try this if columns in visual are from same table. Test the total count.

    IF( ISFILTERED(TestTbl4), 1, COUNT( TestTbl4[AWBNo] ) )
    • andicornejo12's avatar
      andicornejo12
      Helper II
      2 years ago

      hi talespin 

       

      I appreciate so much the follow up. Thank you!!

       

      However this formula is giving me teh same result as the previous one, a one in each row with a total but if I bring in AWB version instead of AWB number is not working anymore. I need to have AWB number in the table 😞

      • talespin's avatar
        talespin
        Solution Sage
        2 years ago

        Hi andicornejo12 

         

        If possible, please share pbix file with all sensitive data removed.