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, my calculation is not coming out with the correct value.

Below is the data being displayed based on selected filters and relationships.  It is properly displaying the expected ID's and it has the proper results for the Fix Attempts Measure.  I am trying to get the total number of records that had Fix Attempts = 1.  As you can see my calculation is not giving the correct result.  If I set a visual Level filter for Fix Attempts =1, the rows that should make up the calculation are properly displayed.

Here is my measure 

 

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

 

 Here is the measure total, for the below data, which is off.

Data Table (all coming from table - Bugs)

Data filtered with Visual level filter, that shows my measure result should be 9, for the data displayed

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))

4 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey Anonymous ,

     

    try the following measure:

    With 1 Fix =
CALCULATE(
    DISTINCTCOUNT( Bugs[WorkItemId] ),
    Bugs[Fix Attempts] = 1
)

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • 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))