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 there,
I am looking for a dax command that will return the instances of particular values from two tables. I have created a match table with numbers relating to certain categories. e.g. 4=Saftey.
This key is the same across two tables with a lookup table. However I want to have this data into a conbined total to give me one score for each of the categories.
Currently I have been creating measures to calculate the number of times a value appears in each table seperatly with the following DAX:
Solved! Go to Solution.
Hi,
The calculation group using tablar editor looked to complex for me currently, so I chose to attempt the problem through a different angel.
Thanks
May I know whether your issue has been resolved? If there is any post helps, then please consider Accept it as the solution. If you still have problems on it, please provide some sample data from your tables and let me know the relationships among them. Thanks a lot!
Best Regards,
Community Support Team _ Caiyun
Hi,
The calculation group using tablar editor looked to complex for me currently, so I chose to attempt the problem through a different angel.
Thanks
@JordanJackson , check if calculation group using tabular editor can help
calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |