Hi, Consider a table
Need a measure to calculate the distinct count of ID if there is only Type = S date wise
It counts other IDs as well. I need only the Distinct Count of those IDs containing Type = "S" only not other than "S"
Count = CALCULATE(DISTINCTCOUNT(Table[ID]), Table[Type] = "S")
Then put it in a table together with the date field to see by date.
For Example:If the ID has 2 entries containing Type "S" & "B" then it should be excluded from the required distinct countIf the ID has 2 Entries containing Type "S" & "S" then it should be counted
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.
Visit our Data Stories Gallery and give kudos to your favorite Data Stories.