Forum Discussion

andicornejo12's avatar
andicornejo12
Icon for Helper II rankHelper 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
Icon for Solution Sage rankSolution Sage
2 years ago

I don't think this is the solution. Requester wanted this to work no matter what column is in visual(same table to another table). 

andicornejo12's avatar
andicornejo12
Icon for Helper II rankHelper II
2 years ago

talespin no is not the full solution as you said, the request is that it works with any column but I dont think there is other way :S