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
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

bvanevr

 

Hi,

 

You can add an ID_Count calculated column as well. Then you can use it a slicer for Users to select records>1

 

ID_Count =
CALCULATE (
    DISTINCTCOUNT ( TableName[ID] ),
    FILTER ( TableName, TableName[Sold to] = EARLIER ( TableName[Sold to] ) )
)

 

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

thanks v-yulgu-msft for the reply.

 

I was able to reproduce result, but would really like a spreadsheet way of doing this.  How my scorecard currently works is

 

The 6 is coming from a Card and the "Filter" is a spreadsheet filtered to include only "Filter.  This allows the user to see the count of Sold to failing a rule and then click "Filter" to see the associated records.  Based on prior answers i was able to get the "Filter" to display, but it does not complress to a single line 

 

I hope this makes sense to you.