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 how to deal with it?

 

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
)

2 Replies

  • 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
)