Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi. Greetings from Brazil.
I am getting troubles to get the expected return. The situation is below:
- I have two different fact tables: one for accounting, and another for purchase order values
PO
Accounting
- I have then created dimension tables - calendar and code (code is like an application code.)
- I need to sum PO values, and accounting for each application. No problem with that.
- For each application, I also need to report biggest sum value - if PO is bigger, PO value; if accounting is bigger accounting value
I have created a Measure:
Measure =
Solved! Go to Solution.
Hi, @th_moreira
It’s my pleasure to answer for you.
According to your description, I think you can create a measure with'summarize'.
Like this:
Measure 3 =
SUMX (
SUMMARIZE (
'Table (3)',
'Table (3)'[code],
"aaa",
IF (
SUM ( 'Table'[po value] ) > SUM ( 'Table (2)'[acc value] ),
SUM ( 'Table'[po value] ),
SUM ( 'Table (2)'[acc value] )
)
),
[aaa]
)
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @th_moreira
It’s my pleasure to answer for you.
According to your description, I think you can create a measure with'summarize'.
Like this:
Measure 3 =
SUMX (
SUMMARIZE (
'Table (3)',
'Table (3)'[code],
"aaa",
IF (
SUM ( 'Table'[po value] ) > SUM ( 'Table (2)'[acc value] ),
SUM ( 'Table'[po value] ),
SUM ( 'Table (2)'[acc value] )
)
),
[aaa]
)
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Wow, thats exactly what I need.
Thank you.
@th_moreira , try a measures like
sumx(values(Table[code]), IF( SUM(fPO[TOTAL]) > SUM(fAccounting[Value]),
SUM(fPO[TOTAL]),
SUM(fAccounting[Value]
)))
Hi.
Thanks for your reply. Almost. The problem is when no application code is selected but other are (like dates, for example), when I think the sum is happening for all lines. Individually is correct.
New ideas?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |