Forum Discussion

scd66's avatar
scd66
Icon for Helper I rankHelper 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's avatar
    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's avatar
scd66
Icon for Helper I rankHelper I
1 year ago

I have shown the current format I am getting in PowerBI Table Visual below with the preferred format shown under that with selected repeating row values replaced with a blank. I have been advised that the DAX formula should be:

New column=  if([Index] = minx(filter(Table, [Column1] = earlier([[Column])) , [index]) , [Column2], blank())

 

but I am struggling to apply this formula successfully with the column headers shown below. I'm really just looking for the formula above to be shown using the coulmn headers in the example shown below: