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