Count Values in a table, where another column is distinct?

[Anonymous]

I currently have a table as such:

Foo   ID

True  234

False 443

False 443

True  678

How can I make a function that counts how many times False comes up with a unique ID? (In this example only once)

[v-eqin-msft]

Hi @Anonymous ,

According to my understanding, you want to use Card visual to display the count of Foo based  on unique ID, right?

You could use the following formula:

countByID =
CALCULATE (
    COUNTROWS ( 'CountTable' ),
    FILTER (
        ALL ( CountTable ),
        'CountTable'[ID] = MAX ( 'CountTable'[ID] )
            && SELECTEDVALUE ( CountTable[Foo] ) = FALSE ()
    )
)

My visualization looks like this:

Is the result what you want? If you have any questions, please upload some data samples and expected output.

Please do mask sensitive data before uploading.

Best Regards,

Eyelyn Qin

[harshnathani · Accepted solution]

Hi @Anonymous ,

What is the expected output ?

You can create a measures

Measure = Count (Table[ID)  and  drag True and False Column in the visualization

or 

MEasure  = DISCTINCTCount(Table[id])

MEasure  = CALCULATE( DISCTINCTCount(Table[id]) , Table [foo] = "False")

Regards,

Harsh Nathani

[AllisonKennedy]

You can put Foo in Rows and ID in Values in a matrix visual. Then set the summarization on ID to Distinct Count by clicking the arrow next to ID.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-aggregates

[Anonymous]

This worked! However is there any way to pull those numbers into a measure so I can insert it into a nice card visual?