Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am working on People's data and I want to derive a number basis multiple criteria being fetched from base data, below is the formula I have inbuilt in excel and want replication of same on Power BI
=COUNTIFS('Base Data'!$M:$M,"V",'Base Data'!$C:$C,Sheet1!$G$7,'Base Data'!$Z:$Z,"new",'Base Data'!$I:$I,Sheet1!$B14,'Base Data'!$O:$O,Sheet1!$E$7,'Base Data'!$O:$O,Sheet1!$E$8,'Base Data'!$J:$J,Sheet1!$C$11)
Can anyone help here??
Thanks In Advance
Calculate(count(Table[Column]);Filter(Table;FiltersCriteria))
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |