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 ,

 

Is this the end result you are looking for?

 

 

andicornejo12's avatar
andicornejo12
Helper II
2 years ago

Hi talespin 

 

Thank you so much for your answer. 

Yes, what you are showing in the picture is what I need to show.

However, the problem is that AWB number can be repeated many times in the fact table, for example the AWB number 14 in your example table can show up twice in the table depending on the dimension you want to break it into. Therefore your solution is giving me the same result as the third column in my example 😞