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

v-echaithra's avatar
v-echaithra
Icon for Community Support rankCommunity Support
1 year ago

Hi scd66 ,

If the provided answer was helpful, please mark it as "Accept as solution" and click "Yes" if you found it helpful, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

 

Regards,
Chaithra.