Forum Discussion

Pascal_15's avatar
Pascal_15
Regular Visitor
2 years ago
Solved

Customizing the row subtotal for a single column

Hi,   I have searched for this and there should actually be a simple solution to this however it is not showing up as an option in my Power BI. So either Im doing something wrong or it's not availa...
Need Help
  • miTutorials's avatar
    miTutorials
    2 years ago

    You can fix this in 2 ways..

     

    1. Move the Date field to 'Rows' instead of 'Values'

    2. Create a measure like below and drag the measure to Values section.

     

     

    Date = IF(ISINSCOPE('Table'[Wijziging]),MAX('Table'[Date]))

     

miTutorials's avatar
miTutorials
Super User
2 years ago

You can fix this in 2 ways..

 

1. Move the Date field to 'Rows' instead of 'Values'

2. Create a measure like below and drag the measure to Values section.

 

 

Date = IF(ISINSCOPE('Table'[Wijziging]),MAX('Table'[Date]))

 

Pascal_15's avatar
Pascal_15
Regular Visitor
2 years ago

Thanks, the second fix worked best, the other created some hierarchy in the rows that I wasn't too happy with. Thanks!