Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am looking to get results for if a country has a certain product (lets say that product is called "product x). For example: I have a list of all the products in Canada. Canada has product x but also has other products. when I use the below IF statement I get a bunch of "YES" and "-". Is it possible to have a seperate table with a column that says " If Canada has the product x only "YES" will appear" as a single row. I am looking to do this for all countries. In the end each country will have its own single row of either "Yes" or "-" meanign that country either has the product or not.
Solved! Go to Solution.
Hi @Domenik ,
1, Create a calculated column in 'products_data_matrix' table.
2, Create a calculated table.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Domenik ,
1, Create a calculated column in 'products_data_matrix' table.
2, Create a calculated table.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
What problem do you face with this formula? Could you share some data, show the result of your formula and also show the expected result.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |