Forum Discussion
Solved
Separate and sum
I have table with values Sas_kod | deb | cred 1209 | 12400 | 0 1209 | 1400 | 900 1209 | 0 | 400 I need create measure wich give me visual (it give me wong result ) Cred or Deb | S...
See if this meets your needs.
V-lianl-msft ty for reply
on big data it work wrong
as
c_o_d_="Deb"&&sas_ in {"0","1"},CALCULATE(SUM('Table'[deb]),ALLEXCEPT('Table','Table'[Sas_kod]))never been hapen as formula Cred or Deb always choose cred value
also this should be done only in measure as many other measures is linked to period and it cant be dublicate
it should be like
Cred or Deb =
IF (
Left([sas_kod],1) in {"0","1"} && [cred] <>0 && [deb] <>0, "Cred and Deb",
IF ( Left([sas_kod],1) in {"0","1"} && [cred] <>0, "Cred", "Deb")
)
and measure
if "cred and deb" then credsum = [cred]-0 and debsum =0 - [deb]
i didnt see deb at all, and all Sum values is same
See if this meets your needs.