Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Incorrect Row Values

Hi,    I have a matrix that is displaying the row values incorrectly. The matrix shows inaccurate row data but an accurate distinct grand total. If I have a meter that belongs to more than one segm...
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , expected output is not clear. What you displayed is correct or wrong?

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi amitchandak  Please see the table.

Meter     Segment          Billing Start Date
1             Direct                 01/11/2018
1              Fixed                  01/10/2018 
1              Flexible             01/10/2018
1             Flexible               01/07/2018
1             Indirect              01/10/2018
1              Indirect            01/08/2018
1             Ultra                01/10/2018


Essentially, the column total is correct as there are 4 distinct start dates. However, when this is by row level the start date for one meter can belong to different segments and is counting it more than once. For instance, in the table 01/10/2018 is counted many times but I only want to count it once - ignoring the other duplicates

 

Thanks