Forum Discussion

Helper I

1 year ago

Solved

Replace repeating row values with blank in a Table Visual

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 ...

Need Help

v-echaithra
1 year ago
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

scd66

Helper I

1 year ago

Here 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:

PBI Table Visual Format.xlsx