Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Exclude Blanks from Distinct Count when in a Matrix

Hello,   I'm currently doing a table on PowerBI for the company I'm in. This table will display tickets worked by the agents, even when the tickets aren't closed/solved. It should also indicate if ...
Need Help
  • Bifinity_75's avatar
    Bifinity_75
    3 years ago

    Hi Anonymous , With a shorter example:

    - I have this table:

     

    - I want count only not blank register in "Count of Billable True ID". I have to create this measure:

    Count = CALCULATE(COUNT('Table Example'[Count of Billable True ID]),
    'Table Example'[Count of Billable True ID]<>BLANK())
     
    - The result is:

    I hope it works, best regards

     

     

     

  • aj1973's avatar
    aj1973
    3 years ago

    Hi Anonymous 

    You either create 2 measures to calculate the sum of field "Billable" = True and then = False, and use them both in your visaul 

    Or,

    Create 2 measures using DISTINCTCOUNTNOBLANK of each column "Billable True" , "Billable False" and then use them both into your visual

aj1973's avatar
aj1973
Community Champion
3 years ago

Hi Anonymous 

You either create 2 measures to calculate the sum of field "Billable" = True and then = False, and use them both in your visaul 

Or,

Create 2 measures using DISTINCTCOUNTNOBLANK of each column "Billable True" , "Billable False" and then use them both into your visual