Dynamic DAX Measure to Count Distinct Rows filtered by separate query
Hi All, I'm pretty new to DAX and struggling to figure this out so any help is greatly appreciated. I have the following data model (simplified): I am trying to write a measure that runs a distinct count on the number of students ('Enrolment'[Student ID]) that have attended an appointment ('Appointments'[Attendance Status]=2). I then want to be able to slice on this measure by date, dimensions etc. The following is currently giving me the correct total over all my data: # Appointment Attendees (Distinct Students) = CALCULATE ( DISTINCTCOUNT('Enrolment'[Student ID]), FILTER(ALL('Appointments'), 'Appointments'[Attendance Status] = 2) However I have a number of other slicers in my report, drawing on values from fact and dim tables. These slicers are not working with the measure in the report , it only displays the original value. Is there a way to re-write the measure so it still works dynamically with slicers? Thanks in advance for your help.
Distinct Count based on calculated percentage measure
I have a table with hundreds of thousands of rows for individual sales, but each sale is designated to a specific group. I have a slicer that selects the desired reporting period (end date) and then I can calculate the total sales for the rolling-12 months based on the selected date both for the national total and each group. Finally, I have created a measure that shows the percent contribution to the nation for each group during the selected time period (Group Sales %). This all works great. What I'm struggling with is getting a simple distinct count of the number of groups whose percent contribution (Group Sales %) is > 1%. See the screenshot below which shows the list of group sales percents, and the distinct count measure I've written. You can see that it's counting each group once, without being filtered by the measure. How can I change this measure to correctly count ONLY the groups where Group Sales % >= .01? The resulting card should show 19, not 92 (which is the count of ALL groups).
Distinct Count for a card visual based on a measure (Visual Level Filter)
Hi, I have created a measure - "Measure1". I have created a table visual with Measure1 applied as a visual level filter with values > 1. Screenshot below: Now I am trying to create a CARD visual showing the count of Drivers that is shown in the above table. But the card visual does not accept a measure as a visual level filter. Count of Distinct Drivers = DISTINCTCOUNT('Table'[Driver Name]) So, I am trying to figure out a DAX measure that would solve this. Any help will be appreciated.
Count distinct name_id
I have the date table and name_id and phases. Each column represents a day for name_id and a Phase. I would like to graph the number of name_id by Phase or month. I tried to distinguish name_id, but when a name_id changes phase along the month it ends up being counted twice on that month. Each color means a phase
