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 ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,
Chaithra.

scd66's avatar
scd66
Icon for Helper I rankHelper I
3 months ago

Just to let you know, I eventually got the display I needed using PowerBI Report Builder which lets you use the 'Previous' Expression (similar to Crystal) to blank out the repeating values that you don't want to show in your report. I can now publish my reports on the PowerBI web platform and embed them in my web portal so that others can access the reports easily via a link. Thanks for all the help and advice last year.