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 everyone,
Please help me to find solution how to fix my measure.
I have a table and in earch row is calculating measure named "Income", in row in calculate corektly, byt in sum and in cart it calculate incorect. I khow that because of context, but how to write a correct folmula?
My measure is
Income =
VAR rozr =
IF(
SUM('Registr VAT'[SUM])=0 && SUM(RW[SUM])=0,
BLANK(),
(
SUM(FS[SUM])- SUM('Registr VAT'[SUM])-SUM(RW[SUM])
)
)
RETURN rozr
Link to .pbix https://we.tl/t-bPXOmpkpnu
Solved! Go to Solution.
Hi @andrieskoo
Please refer to the sample file with the solution https://we.tl/t-S1IzTm6gBN
Income =
SUMX (
SUMMARIZE ( Contracts, Contracts[ID], Contracts[SIGN_DATE], Contracts[STATUS] ),
VAR VATSUM = CALCULATE ( SUM ( 'Registr VAT'[SUM] ) )
VAR RWSUM = CALCULATE ( SUM ( RW[SUM] ) )
VAR FSSUM = CALCULATE ( SUM ( FS[SUM] ) )
RETURN
IF (
VATSUM <> 0 || RWSUM <> 0,
FSSUM - VATSUM - RWSUM
)
)
Hi @andrieskoo
Please refer to the sample file with the solution https://we.tl/t-S1IzTm6gBN
Income =
SUMX (
SUMMARIZE ( Contracts, Contracts[ID], Contracts[SIGN_DATE], Contracts[STATUS] ),
VAR VATSUM = CALCULATE ( SUM ( 'Registr VAT'[SUM] ) )
VAR RWSUM = CALCULATE ( SUM ( RW[SUM] ) )
VAR FSSUM = CALCULATE ( SUM ( FS[SUM] ) )
RETURN
IF (
VATSUM <> 0 || RWSUM <> 0,
FSSUM - VATSUM - RWSUM
)
)
Thanks a lot!
@andrieskoo , Try like
Income =
VAR rozr =
Sumx(values(Table[ID]),
IF(
SUM('Registr VAT'[SUM])=0 && SUM(RW[SUM])=0,
BLANK(),
(
SUM(FS[SUM])- SUM('Registr VAT'[SUM])-SUM(RW[SUM])
)
)
)
RETURN rozr
Thax, for Your help, but it doesn't workr as I expect
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |