User Profile
New_be
Helper V
Joined 6 years ago
User Widgets
Contributions
Failed to get correct total
Hi expert, As per subject, I failed to get a correct total headcounts as in the image. To create matrix table visual, I created a measures to calculate the headcount: Headcount = CALCULATE( MIN('Leavetable'[Headcount]), ALLEXCEPT(Calendar, Calendar[YearMonth]), ALLEXCEPT(EmpProfile, EmpProfile[Department]) ) Per department level (department coming from EmpProfile table), I got a correct value, but on the YearMonth level (coming from calendar table) to show the total from the sum of values in department level, I failed. Please show me a correct way to get the total per YearMonth in my case explained in the image attached.My filter does not working
Hi expert, I have a simple question (shoulod be simple, but I cannot get the answer). I have 3 tables. 2 dimensions (Calendar & area) and 1 fact table. From matrix table, I wanted to created a visual like below with reporter at row, and YearWeek as column and YES if there is a title registered in DAB table. But with my current measure, when I filter on the plant, for example MY, it will show all reporters. It should only return reporter under plant MY. But now it shows all. Below is my measure; YesOrNo Gemba TEST = VAR RegistrationCount = CALCULATE( COUNT('DAB Action List'[Title]) ) RETURN IF(RegistrationCount > 0, "YES", "NO") Visual that I desired. If I click on MY, it will show only MY registration. If JAP, it will show JAP only.
