Forum Discussion
Helper IReplace repeating row values with blank in a Table Visual
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
Super UserFor this to work, it's essential to identify which columns cause the room number to appear multiple times. The table must be sorted first by room number and then by those columns, as the formula checks whether the values in the current row match those in the previous row. Users should not change the sorting order; otherwise, blanks may appear not only after the first row but also unexpectedly within each room number group. Additionally, multiple tables can introduce further complexity. The key question is: Is this a want or a need?
scd66Here is the format I have in my Table visual with the preferred result shown under it. The Room ID column is the unique identifer used to sort the data, but I don't know how to apply the 'Earlier' formula that replaces the repeating row with a blank if it equals the first unique row. The values I don't want to repeat are the 'NIA/NUA Room Areas' fields, the 'Capacity' field and the 'Location Notes' fields highlighted in yellow. The Excel file is attached: