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

Bifinity_75's avatar
Bifinity_75
Solution Sage
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

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello Bifinity,

     

    Your suggestion seems to be working as intendedon my dashboard !

    Thank you for helping me, I thought it wouldn't work with a measure but I was wrong !

    As my table get filled over time and start over at the beginning of each week, I'm not 100% sure it's all right, but if I notice anything that may raise additionnal question, I'll seek for help again, I guess ?

     

    Thank you again for your help !

     

    Horus