Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
86 | |
84 | |
68 | |
49 |
User | Count |
---|---|
138 | |
111 | |
103 | |
64 | |
60 |