topic Re: Calculated count in DAX Commands and Tips

Calculated count

Anonymous — Mon, 16 Aug 2021 17:40:19 GMT

Evening,

I'm driving myself mad trying to calculate a table for commisison purposes.

I'm using data which inlcudes:

Lead ID (customer unique number)

Quote ID (unique number)

Status

Each customer can have multiple quotes against it, and each quote can have multiple statuses against it which necessates the need for me to filter the in a table (all good so far).

I can calculate the amount of total sales and a fixed commission against this but need to find a way to count the number of times the Lead ID appears and then look up the associated commisison value in a related table.

How do i create a column/dax which calculates the amount of times the Lead ID is repeated in a filtered table?

Re: Calculated count

Greg_Deckler — Mon, 16 Aug 2021 17:56:23 GMT

Anonymous COUNTROWS(FILTER(...))

But hard to know for sure. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.