DISTINCT COUNT WITH FILTER

Question

Hi, I am trying to create a measure that is going ot divide the total number of ditint rows by the total number of distint rows that are in the category "A" to see the % of rows that are category "A".

I have tried different formulas

DD_Collector_%_OpenTransactions =

VAR COLL_TRANSACTIONS = CALCULATE(FILTER(Table1,Table1[a_A/B] = "A"), DISTINCTCOUNT(Table1[Transactions]))

VAR COLL_TRANSACTIONS_A = CALCULATE(DISTINCTCOUNT(Table1[Transactions]), FILTER(ALL(Table1[a_A/B], Table1[Status]),Table1[a_A/B] = "A" && Tabe1[Status] = "Open"))

VAR COLL_TRANSACTIONS_A2 = CALCULATE(DISTINCTCOUNT(Table1[Transactions]), Table1[a_A/B] = "A" && Table1[Status] = "Open")

RETURN

COLL_TRANSACTIONS_A / COLL_TRANSACTIONS

COLL_TRANSACTIONS_A and COLL_TRANSACTIONS_A2 are the same I just did a try bith both but they don't work

lbendlin · Answer

You will want to use DIVIDE()&nbsp; to protect against cases of division by zero.
&nbsp;
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216 Please show the expected outcome based on the sample data you provided. https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Forum Discussion

DISTINCT COUNT WITH FILTER

1 Reply

Related content

count distinct

Distinct Count with filter

Distinct Count

Distinct Count, Filter

Distinct count