I have a table visual in PowerBI shown below where I have split total room areas into percentages of room owner where the room is shared. Is there a formula that could be written to replace selected repeating row values with a blank? I have a unique column called Room ID Code and want the repeating row to show the Capacity value only once in the first row, for example 'Room No.101 Main Entrance Foyer' shown in the screen shot below is split 50/50% between two owners and it shows a row for each 50% split, and repeats the Capacity value again in the next row. Is there an easy formula that could be written for the Capacity column which would replace the repeated Capacity row value with a blank so it only appears once and I can then have a running total for the Capacity column? Should I take a copy of the column and then apply the formula to that, as some of my calcuated columns for percentage splits of the room areas are referencing the total area of the room in each repeated row and I don't want to mess up the calculations as I also want to replace the repeating total room area duplicates with a blank? I tried using the matrix visual but it was becoming huge when I expanded it as I have so many columns in my visual. Any advice would be greatly appreciated, thanks.

Hi scd66 ,As per your data context i have reframed the measure, please try the below DAX measure, make sure you are using field names correctly and let me know if it works.Capacity Supp =IF ('Locations UDFs'[Room ID Code] = CALCULATE (MIN ( 'Locations UDFs'[Room ID Code] ),FILTER ('Locations UDFs','Locations UDFs'[Room ID Code] = EARLIER ( 'Locations UDFs'[Room ID Code] ))),'Locations UDFs'[Capacity],BLANK())Regards,Chaithra

Replace repeating row values with blank in a Table Visual

Forum Discussion

24 Replies

Related content