User Profile
ki
Frequent Visitor
Joined 5 years ago
User Widgets
Contributions
Creating a Measure Based on 2 Tables
Hello, Trying to create a measure that shows revenue for specific product category as percentage of total revenue. Below are the 2 tales. This is of course easily achievable by creating a relationship b/n those and then creating a visual. Yet, I need it is a measure 😞 Want to avoid long coding as the real data is bigger/complex (e.g. I can combine filter and sumx in Table 1 given that I know the category of each product) and want to avoid joining tables. Category A = 43% of Total RevenueHelp Needed w/ Data Model :-(
Hello community, Hope you can help me out as I invested a lot of energy in this and couldn't get this working 😞 Still fairly new to Power BI modeling. The scenairos is the following - I hava a dataset froming from e-learning platform and want to be able to manually assign employees (or roles) to specific set of learnings and track their progress with it. The following tables are available: - Employees Master Data - holds data like name, e-mail (this is unique identifier), country, job title, etc - Fuse Status Data - holds data on the status of each learning plan (LP) that an employee is registered on - not started, in progress, completed; along with unique ID of the LP and some other data; have also created a few KPIs here - Mapping - this is where I am manually creating the so-called success plans (SP) - pretty much saying that SP has an ID and then holds certain LPs - The connections are as follows: many-to-many on SP ID and then one-to many on LP ID Once I try to create a view for a specific employee on getting status, I get rows for each LP part of the SP duplicating every possible status instead of having one row per LP holding the real status. Adding a few screenshots. Hope you can help me out - I am sure this is very simple and I am missing something! Kiril
