March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
@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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
23 | |
15 | |
12 | |
9 | |
8 |
User | Count |
---|---|
39 | |
32 | |
24 | |
16 | |
13 |