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))
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))
    • selimovd's avatar
      selimovd
      Most Valuable Professional
      5 years ago

      Hey Anonymous ,

       

      what is Bugs[Fix Attempts]?

      Is that a column or a measure?

       

      Best regards

      Denis