fixed values count irrespective of the field displayed in the grid
Hi, I'm trying to count milestones in the pic(pic 1) to find out how many milestones are tied to a project by count distinct, but when I add the milestone code to the grid the milestone count defaults to 1. I want to show milestone counts(say 4,3,2) even if I add the Milestone to the grid (2nd pic) The Projects and Milestones are separate tables joined by Proj ID (1:m) In Tableau I would use a Fixed LOD to achieve this result. Please help with a DAX solution for this one. Thanks, Raj
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 of Blank Lines
Hey Everyone, i am essentially needing a distinct count of all the lines below (displayed in the left) to be reflected in the card to the right. I need a calculation to look at a distinct count of all items which have a blank in order quantity (disregard the placeholder coulumn). I essentially need the Count of Desc column of 140 to be reflected in the card to the right. My table names are Articles (i am using Desc in this table), Purchase History ( I am using Order Quantity in this table)Count occurences of days which has a summed total below a certain value
Hi Community, A question for a personal dashboard I have. I am counting calories (yeah, I know) and I got this source calories4 with multiple entries per date. The uniqueness in this source is the piece of food I ate with the number of calories it holds. For example the month May, in the source this month got 214 entries, which represent the food I ate during the 31 days May knows. In PowerBI the source is represented as a sum of calories per date. Today I am trying to visualize the number of days on which I ate less than 2500 calories. The month May has 7 of this kind of days and as I think I need to distinct count the dates which will be 31 in my example and then filter on those which has a sum of less than 2500 but for some reason I can't get this done: NumOfGreenDays = CALCULATE( DISTINCTCOUNT( calories4[Datum] ), FILTER( calories4, calories4[Calorien] <= 2500 )) Where am I making the mistake? Thanks in advance and kind regards, Aad
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 of Weeks based on Date filter
Hi, I am trying to create a measure to show number of Weeks from Calendar table based on slicer date filter. This is what I have done so far CountWeeks = CALCULATE( DISTINCTCOUNT('Calendar'[YearWeek]), FILTER(VALUES('Calendar'), 'Calendar'[Date]>=[Minimum date] && 'Calendar'[Date]<=[Maximum date])) it is working fine in visuals like card or as a single value, but when I am using it in table with columns it is always showing 1, so it is counting per column row, I would like to get the same value(91) regardless of additional variables. Slicer for 'Calendar'[Date]: Card visual: Connection: MaterialTransactions is my table with all data needed Calendar is my calendar table, also connected with different tables. Expected result:How To Count Distinct States Based Distinct PersonsNames
Hi! I have two columns in a table. State and PersonsName. I want to calculate the count of distinct states that contain more than 10 distinct PersonsName. Almost like how a GROUP BY in SQL would work. Any ideas on how to accomplish this? Thank you!
DIstinct Count of Category Name Filtered by One of Multiple Demand Columns
Hi everyone, I'm unable to get the correct distinct count of my product based on whether there is current demand, while I have two different demand columns which do not overlap in row entries. I provide simplified data in which I want it to be calculated like the following: As you can see, I want my Product column to be distinctly counted based on whether it is also populated by the Current Demand measure (this measure directly refencing a demand column in my data, since I want to create an explicit rather than implicit measure for Excel use). My thinking has been to create the following: Count=CALCULATE( DISTINCTCOUNT(ProductTable[Product],[Current Demand] <> BLANK()). However, it is not working. Please note that I don't have access to the most recent DAX functions such as DISTINCTCOUNTNOBLANK, so I hope there is still a way around this. Any help will be much appreciated.
