Forum Discussion

bvanevr's avatar
bvanevr
Icon for Advocate II rankAdvocate II
8 years ago

DAX count with count filter

I am needing help with a complex formula needed for error checking.  This all needs to be done in DAX (not in the Query editor) as there are dynamic filters in the report that need to impact these co...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi bvanevr,

 

Create a simple measure like this:

ID count = DISTINCTCOUNT(TableName[ID])

Add field [Sold to] and measure [ID count] into table visual, add field [status] into slicer. Click the table visual, apply a visual level filter like below.

Best regards,
Yuliana Gu