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.
Hi together, short question in the round: I want to isolate and read the value 2 from different columns of a table.
The columns awa60 to wa63 can store three different values: 0, 1 and 2.
For example:
=calculate(SUM(ca[awa60]);ca[awa60])=2+
calculate(SUM(ca[awa60]);ca[awa61])=2+
calculate(SUM(ca[awa60]);ca[awa62])=2+
calculate(SUM(ca[awa60]);ca[awa63])=2
My measure does not work. Can someone help? greetings Guenter
Hi @gprg,
Could you please provide more description about your requirement? Please share sample data in source table and show us your desired output with example. Besides, if you were encountering problem in PowerPivot, I would suggest you post question on more related forum.
Regards,
Yuliana Gu
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 |
---|---|
15 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |