Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
RAHULBANDI
Helper II
Helper II

Double Header in Matrix

‎09-21-2022 08:09 AM

Hi 

I have following Data-set , I'm Looking to create Double header in Matrix

I have created new table

Table 2 = CROSSJOIN('Table',union(row("Measure","Total Amount"),row("Measure","Total Units")))
RAHULBANDI_0-1663772665465.png

 

 and created measure >> Value = if([Measure]="Total Amount",[Sale Amount],[Units Purchased])
RAHULBANDI_1-1663772719656.png

 

expected output: 

RAHULBANDI_2-1663772903036.png

 

 Can someone please look into this
please let me know if i need to make any changes in vizualisation pane.
 
data:
Sale DateType of SaleCustomer NameSale AmountUnits Purchased
1-Jan-22OnlineCustomer19258153
1-Jan-22OnlineCustomer222933173
1-Jan-22OnlineCustomer3310909120
1-Jan-22OnlineCustomer373247155
1-Jan-22OnlineCustomer671747197
1-Jan-22OnlineCustomer676217159
1-Jan-22OnlineCustomer681435102
1-Jan-22OfflineCustomer684967135
1-Jan-22OnlineCustomer83500184
2-Jan-22OfflineCustomer135657113
2-Jan-22OnlineCustomer355180113
2-Jan-22OnlineCustomer515614167
2-Jan-22OnlineCustomer532379155
2-Jan-22OfflineCustomer692294122
2-Jan-22OnlineCustomer698405149
2-Jan-22OfflineCustomer694520102
2-Jan-22OfflineCustomer6917307147
2-Jan-22OnlineCustomer69920170
2-Jan-22OfflineCustomer692909177
3-Jan-22OnlineCustomer4655536115
3-Jan-22OnlineCustomer534280129
3-Jan-22OfflineCustomer559644116
3-Jan-22OfflineCustomer703377185
3-Jan-22OnlineCustomer7012737162
3-Jan-22OnlineCustomer701817139
3-Jan-22OnlineCustomer706497194
3-Jan-22OnlineCustomer71749160
3-Jan-22OnlineCustomer712226132
4-Jan-22OfflineCustomer454180150
4-Jan-22OfflineCustomer494814148
4-Jan-22OfflineCustomer513857166
5-Jan-22OnlineCustomer254363124
5-Jan-22OfflineCustomer4612695182
5-Jan-22OnlineCustomer175962115
5-Jan-22OfflineCustomer173043172
6-Jan-22OnlineCustomer261870166
6-Jan-22OfflineCustomer303610141
6-Jan-22OnlineCustomer4614076171
6-Jan-22OnlineCustomer481571199
6-Jan-22OfflineCustomer58341194
6-Jan-22OnlineCustomer5065174192
7-Jan-22OnlineCustomer348741153
7-Jan-22OfflineCustomer372823158
7-Jan-22OnlineCustomer4614076118
7-Jan-22OnlineCustomer63358164
8-Jan-22OfflineCustomer2025996113
8-Jan-22OnlineCustomer2810494126
8-Jan-22OnlineCustomer355547195
8-Jan-22OnlineCustomer537075135
8-Jan-22OfflineCustomer559644164
8-Jan-22OfflineCustomer94330196
9-Jan-22OfflineCustomer125174118
9-Jan-22OfflineCustomer1220193126
9-Jan-22OnlineCustomer155296113
9-Jan-22OnlineCustomer235353186
9-Jan-22OnlineCustomer5615309149
9-Jan-22OnlineCustomer721282171
9-Jan-22OfflineCustomer724358196
9-Jan-22OnlineCustomer732374155
9-Jan-22OnlineCustomer738726135
9-Jan-22OfflineCustomer83534132
10-Jan-22OnlineCustomer94560167
10-Jan-22OnlineCustomer3217319145
10-Jan-22OnlineCustomer349694126
10-Jan-22OnlineCustomer345717149
10-Jan-22OfflineCustomer483039121
10-Jan-22OnlineCustomer578115124
10-Jan-22OfflineCustomer71562128
10-Jan-22OnlineCustomer711478172
11-Jan-22OfflineCustomer5034759186
11-Jan-22OnlineCustomer5027792103
11-Jan-22OfflineCustomer743672152
11-Jan-22OnlineCustomer7413916116
12-Jan-22OnlineCustomer5033213171

 

 

Labels:
Message 1 of 2
207 Views
0
1 REPLY 1
amitchandak
Super User
Super User

‎09-21-2022 08:13 AM

@RAHULBANDI , I think calculation group can hel. refer my example

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

 

Also

column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795



Message 2 of 2
201 Views

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Fabric Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

View All