Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Count function not applying values in chart

First time question-er here.

 

I'll try to keep it simple.  Can't share data due to privacy issues.

 

1)Center table: list of invoices that have gone through a center

2)Dispute table: list of invoices that have had disputes

3)Fact table: all invoices, sales $

 

The first two tables are related in a 1:* relationship to the fact table

 

I have added two columns to my Fact table that are simply a yes/no based on whether that invoice appears in the corresponding tables: "Is Dispute Invoice" and "Is center invoice"

formula example: Is Dispute invoice = if(isblank(related('Dispute info'[Dispute Invoice ID])), "No", "Yes")

 

I have TRIED to create a measure that looks at the % of disputes: 

% disputes = divide(count('Dispute info'[Dispute Invoice ID]),CALCULATE(sum(Sales $], filter('Fact', 'Fact'[Is dispute invoice]="yes")))

 

 

This seems to work fine until I drop in (to my table visual) the "Is Center Invoice".  Say there are a total of 9 dispute invoices.  The first table I attached calculates this correctly.  The second table is still using a count of 9 invoices, even though I've dropped in the Center yes/no column.  How do I get the count function to take into account any columns I may drag into the visual?!

 

Really hope this makes sense...