Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PowerBI Counting Unique Strings

Hello I have been trying to troubleshoot this issue for the last few days and have had little luck. Hopefully someone will be able to help. I have a gauge visualization where I am trying to show the ...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    I think the below measure should give you the desired results:

    Count Measure = 

CALCULATE(
    COUNTROWS( 'Table' ),
    'Table'[Discipline] = "East",
    NOT 'Table'[Workflow] IN {"Design Active", "Cancelled", "On-Hold" ,"Use Typical"},
    'Table'[Designer Inspection] IN {"Not Complete", "Complete","Not Required"}  
)

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Fowmy You are a god among men! Thank you so much!!