cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ph1234
Frequent Visitor

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 segment , it's billing date is getting counted in both their total's if the meter had been billed in one segment for a specific date then re-billed in another segment later on in the year for the same date. 

 

The Measures I have are below: 

Billed Months = DISTINCTCOUNT('Data'[Billing Start Date]

Total Billed Months = CALCULATE(SUMX(DISTINCT('Data'[Meter]), [Billed Months]))

 

Say a meter belongs to 5 different segments in a year, it then gives the below output: 

 

Segment    Total Billed Months

Direct                      1

Fixed                       1

Flexible                   2

Indirect                   2

Ultra                       1

Total                      4

 

Essentially, I only want to count the billing start date it if it appears in more than one segment for a meter

 

Any help is greatly appreciated

 

Thanks

2 REPLIES 2
amitchandak
Super User IV
Super User IV

@ph1234 , 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.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors