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
Thanks for reading this.
I have a USERELATIONSHIP between two tables , the "normal" measure with USERELATIONSHIP work as it should and it looks like this:
CALCULATE(sum(Table[Total]),Table[Month] = "202306" , Table[Salemonth] >= "202306",USERELATIONSHIP(Table[SaleMonth],Monthtable[Year-Month]))
Solved! Go to Solution.
@Wresen
I modified your measure and now the result should be as expected. However, I am not sure the context for this meaure in your real application, please make necessary changes.
Not working Sales Proc Calc =
CALCULATE(
sumx(
ADDCOLUMNS(
SUMMARIZE( 'Table' ,'Month'[Year-Month] , 'Table'[Item] ),
"Calc" ,
CALCULATE(
sum('Table'[Total]),
'Table'[Month] = "202301" ,
'Table'[SalesMonth] >= "202301"
)
),
[Calc]
),
USERELATIONSHIP('Table'[SalesMonth],'Month'[Year-Month])
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
I had this exact same problem, and your solution worked perfectly thank you!
@Wresen
Try below measure:
Calc on Item =
SUMX (
ADDCOLUMNS (
SUMMARIZE ( 'Table', 'Table'[Month], 'Table'[Item] ),
"Calc",
CALCULATE (
SUM ( Table[Total] ),
Table[Month] = "202306",
Monthtable[Year-Month] >= "202306",
USERELATIONSHIP ( Table[SaleMonth], Monthtable[Year-Month] )
)
),
[Calc]
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
pls try this
Calc on Item = sumx(
ADDCOLUMNS(
SUMMARIZE( Table' ,'Table'[Month] , 'Table'[Item] ),
"Calc" ,
CALCULATE(sum(Table[Total]),Table[Month] = "202306" , Table[Salemonth] >= "202306",
TREATAS(VALUES(Table[SaleMonth]),VALUES(Monthtable[Year-Month])))
),
[Calc]
)
if this doesn't help please share the file to help you
@Wresen
Attach your PBIX file and explain the expected result.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi
Attached a file:
The Measure "Not Working Sales Proc Calc" should behave as Salescount.
(i need it to have in the format i have it now with Summarize since this is only a little part of the code and calculation you see)
/Thanks for any help to figure this out 🙂
https://drive.google.com/file/d/1jqdQXOM4sgKY96RxVQoxf8QKndx9A5jX/view?usp=sharing
@Wresen
I modified your measure and now the result should be as expected. However, I am not sure the context for this meaure in your real application, please make necessary changes.
Not working Sales Proc Calc =
CALCULATE(
sumx(
ADDCOLUMNS(
SUMMARIZE( 'Table' ,'Month'[Year-Month] , 'Table'[Item] ),
"Calc" ,
CALCULATE(
sum('Table'[Total]),
'Table'[Month] = "202301" ,
'Table'[SalesMonth] >= "202301"
)
),
[Calc]
),
USERELATIONSHIP('Table'[SalesMonth],'Month'[Year-Month])
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 |
---|---|
133 | |
91 | |
88 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
73 | |
68 |