Forum Discussion

KarolSJZ's avatar
KarolSJZ
Frequent Visitor
8 years ago
Solved

Matching data in columns (PivotTable)

Im new here so first I would like to say Hi :)   I stuck with a "pivottable". I need to match: if "Zamowienia PLN">0 and appear in both columns: -4 and -5 then 1, if not match 0. Can someone help ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    KarolSJZ,

     

    Drag measure below to visual level filter and set Show items when the value is 1.

    Measure =
IF (
    CALCULATE ( SUM ( Table1[Zamowienia PLN] ), Table1[rejestr] = -5 )
        > 0
        && CALCULATE ( SUM ( Table1[Zamowienia PLN] ), Table1[rejestr] = -4 )
            > 0,
    1
)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

KarolSJZ,

 

Drag measure below to visual level filter and set Show items when the value is 1.

Measure =
IF (
    CALCULATE ( SUM ( Table1[Zamowienia PLN] ), Table1[rejestr] = -5 )
        > 0
        && CALCULATE ( SUM ( Table1[Zamowienia PLN] ), Table1[rejestr] = -4 )
            > 0,
    1
)
  • KarolSJZ's avatar
    KarolSJZ
    Frequent Visitor
    8 years ago

    v-chuncz-msft,

    Thank You for answer.

    I appreciate the help, it works perfectly :)

     

    In Polish version of PBI I had to use ";" instead of "," in the IF formula and of course changed Table1 with the real name of the table.

    Measure =
IF (
    CALCULATE ( SUM ( Table1[Zamowienia PLN] ), Table1[rejestr] = -5 )
        > 0
        && CALCULATE ( SUM ( Table1[Zamowienia PLN] ), Table1[rejestr] = -4 )
            > 0;
    1
)