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.
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?
Solved! Go to Solution.
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 )
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 )
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 )
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |