Market Share Percent In Ribbon Chart - % Of Column Total
We are trying to mimic The 100% stacked bar chart's % of column total calculation on a ribbon chart. So essentially a market share % of total calculation for each date we have. We've tried creating a measure that we thought would work but it has not: AllDivisionTracking := CALCULATE ( [TrackingNumbers], ALL ( Divisions ) ) PercentOfTotal := DIVIDE ( [TrackingNumbers], [AllDivisionTracking] ) This measure does not seem to work when inserted as the measure on a ribbon chart. The ribbon chart seems to make this calculation over the entire date range instead of limiting it to each day as we would have expected.
Conditional relationship for multiple tables
Hi, I have 4 tables logins, ConnectedUsers,FacilityCode, ProviderCode. Basically in ConnectedUsers table i have: Provider_Name System_Code Facility_Code RegisteredUsers AHSE GAYA 10 CCMS GAYA AA02 4 AHSE GAYA 6 logins EventID System_Code Facility_Code 01 GAYA AA02 02 GAYA I have a measure that calculates logins based on event ID (count), however, I want the system to check if facility code in connectedusers table is blank then it should take system_code registered users.
