Forum Discussion

luis_pflucker's avatar
luis_pflucker
Icon for Helper II rankHelper II
5 years ago

how to group rows with calculated columns

Hi, I have a table with calculated columns  as you see in the attached picture, I am trying to group in same row for example Defect ID 32013, 32026, 32053, etc where as a result the column #TCs Bloc...
Need Help
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

If you need a new column in the visual which returns "Yes" for values greater than 0 else "No", then create a measure along the lines of:

Yes or no = IF(SUM( Table [BUATotro]) >0, "Yes", "No")
or
If BUATotro is a measure,

Yes or no = IF([BUATotro measure] >0, "Yes", "No")

luis_pflucker's avatar
luis_pflucker
Icon for Helper II rankHelper II
5 years ago

Thanks Paul, but still had the issue because I wanted to group even Yes or Not, where each Defect ID is suming #TCs Blocked in only one row.

What I did, is based on your suggestion, I calculated a column Yes or No, and on this new column I choose not count, not summarize, but Last (as attached). Thanks!!!