Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Issue Calculating Count when using Measure to Filter Data

I am having issue crafting a measure to display the total number of records based on a measure displayed in a Table.  I would have thought this was easy, especially after seeing This Thread.  However...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Try this measure

    With 1 Fix = CALCULATE(DISTINCTCOUNT(Bugs[WorkItemId]),FILTER(values(bugs[id]),[Fix Attempts]=1))
Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI selimovd 

 

When I do that, I get an error - A function 'CALCULATE' has been involved in a True/False expression that is used as a filter expression.  This is not allowed.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

Try this measure

With 1 Fix = CALCULATE(DISTINCTCOUNT(Bugs[WorkItemId]),FILTER(values(bugs[id]),[Fix Attempts]=1))