Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
moeconsult
Helper V
Helper V

Matrix not showing correct Ground and subtotal

Please see attached Matrix, I am doing disticnt count of attendance so all value returned for each colomn are 1 but the report is also showing Total as 1 which is wrong,  I need help with this as soon as possible thanks.

 

 
 
3 REPLIES 3
v-xuding-msft
Community Support
Community Support

Hi @moeconsult ,

You could try the function of SUMX firstly, like this:

Measure = SUMX(Your_Table,[That_Measure])

The attachment is not working. If the formula can't help you, please attach a new one.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Please see sample data and Table report. What I want to create a matrix with my report.

 

I have students attended different sessions from different schools and regions. One student can have many sessions booked but it doesn't matter as I want am after is to Unique of the earliest attendance as u can see Bronte school appeared 3times but I want the first time they attendede  using the attendance column and date . I hope my explanation is good enough . Thanks.Sample.JPG and the date. Date and phase be used as Filter.

 

 

 

EVENTED Table       
Org NameStage        
Bronte SchoolPrimary        
Ola SchoolSecondary        
Jame SchoolOther    Sampple Table Report
      RegionLPOrgNameDate
Sess Table    NENorth JamBronte School02/03/2020
AttendanceStatus    NENorth JamBronte School18/03/2020
10090Attended    NENorth JamBronte School19/03/2020
10080Absent    NWNorth WestOla School19/03/2019
10070Pending    ENEast NorthJames School18/03/2020
          
Contractors Table        
RegionLP        
NENorth Jam        
ENEast North        
NWNorth West       
          
          
Time Table        
02/03/2020         
18/03/2020         
19/03/2020         

To sum up the line level values of distinct you need a context. You need to try one of the following. Values or summarize to give a group by context

sumx(values(table[ID]),[Measure])
sumx(summarize(table,table[ID],"_dist",[Measure]),[_dist])

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.