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 look into the pbix file attatched, where we tried to reproduce the scenario with your sample data.
Compare the Location Notes with Location Notes Display and Functional Suitability with Functional Display.
You can try these below DAX measures to build calculated columns i.e, Location Notes Display and Functional Display.
For Index Column:
Index =
RANKX(
ALL('Locations UDFs'),
'Locations UDFs'[Room ID Code]
& "|" & 'Locations UDFs'[Room Function]
& "|" & 'Locations UDFs'[Activity Tag]
& "|" & FORMAT('Locations UDFs'[% Activity Tag], "0.00"),
,
ASC,
DENSE
)
For Capacity Display Column:
Capacity Display =
VAR CurrentRoomID = 'Locations UDFs'[Room ID Code]
VAR MinRow =
CALCULATE (
MIN ( 'Locations UDFs'[Index] ),
FILTER ( 'Locations UDFs', 'Locations UDFs'[Room ID Code] = CurrentRoomID )
)
RETURN
IF ( 'Locations UDFs'[Index] = MinRow, 'Locations UDFs'[Capacity], BLANK() )
For Location Notes Display:
Location Notes Display =
IF(
ISBLANK('Locations UDFs'[Capacity Display]),
BLANK(),
'Locations UDFs'[Location Notes]
)
For Functional Display column:
Functional Display =
IF(
ISBLANK('Locations UDFs'[Capacity Display]),
BLANK(),
'Locations UDFs'[Functional Suitability]
)
If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.
Regards,
Chaithra.
Helper ICould you perhaps show a screenshot showing how the DAX measures look in your sample file in the formula bar and I could try copying?