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
Community SupportHi scd66 ,
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
scd66Hi, Here is a sample of the data in the link below showing the repeating rows and the required result shown below this. I can do this with Crystal Reports by suppressing duplicate row values if the value of the index column equals the earlier, or previous, row, but can't seem to find a similar formula in PowerBI which gives the same result. I think the 'EARLIER' command might work but not sure how to apply this in a formula or what the formula should look like. The aim is to show the Capacity column value only once so that I can have an accurate running total in the table visual, so I would like to replace the repeating values with a 'blank'.