Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Greetings supporter,
I have two values when i put on the total first value calculated by column that is right, and Second value by Row that is wrong as the below total. how to make both value calculate by columns
your supprot is highlty appreciated
Solved! Go to Solution.
@Anonymous:
Create a date dimension table and use the columns from that table in your visual instead of the date columns from the fact table.
You can use this code for the calculated table:
Date =
GENERATE (
CALENDARAUTO (),
VAR Yr = YEAR ( [Date] )
VAR Mn = MONTH ( [Date] )
VAR Qr = QUARTER ( [Date] )
VAR MnQ = Mn - 3 * (Qr - 1)
VAR Wd = WEEKDAY ( [Date], 2 )
RETURN ROW (
"Year", Yr,
"Year Quarter", FORMAT ( [Date], "\QQ-YYYY" ),
"Year Quarter Sorting", Yr * 100 + Qr,
"Quarter", FORMAT ( [Date], "\QQ" ),
"Year Month", FORMAT ( [Date], "MMM-YYYY" ),
"Year Month Sorting", Yr * 100 + Mn,
"Month", Mn,
"Day of Week", Wd,
"Week Day", FORMAT ( [Date], "dddd" )
)
)
@Anonymous:
Create a date dimension table and use the columns from that table in your visual instead of the date columns from the fact table.
You can use this code for the calculated table:
Date =
GENERATE (
CALENDARAUTO (),
VAR Yr = YEAR ( [Date] )
VAR Mn = MONTH ( [Date] )
VAR Qr = QUARTER ( [Date] )
VAR MnQ = Mn - 3 * (Qr - 1)
VAR Wd = WEEKDAY ( [Date], 2 )
RETURN ROW (
"Year", Yr,
"Year Quarter", FORMAT ( [Date], "\QQ-YYYY" ),
"Year Quarter Sorting", Yr * 100 + Qr,
"Quarter", FORMAT ( [Date], "\QQ" ),
"Year Month", FORMAT ( [Date], "MMM-YYYY" ),
"Year Month Sorting", Yr * 100 + Mn,
"Month", Mn,
"Day of Week", Wd,
"Week Day", FORMAT ( [Date], "dddd" )
)
)
Hi @Anonymous,
You can take a look at the following link about Dax measure total calculation issue if helps:
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
@Anonymous you can PM me and we could do a zoom to look together.
what do you meane about PM?
Private message*
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
8 |
User | Count |
---|---|
13 | |
12 | |
11 | |
10 | |
9 |