(DAX) Show percentage of total

[Anonymous]

Dear all,

Hope you are all well in this hard times.

I came accross a task which I dont seem to find a solution (maybe is because I am narrowing and focusing to much over the same thing) but i need your help.

The main goal is to have a card or cluster grapg showing the percentage of the total. Let me explain:

My data looks something like this:

Month	Country	Client	Logistic
Jan	DE	A1	Distributed
Jan	DE	A1	Distributed
Jan	DE	A1	Distributed
Jan	DE	A1	Distributed
Jan	DE	A1	Distributed
Jan	DE	A1	Received
Jan	DE	A1	Received
Jan	DE	A1	Received
Jan	DE	A1	NotReceived
Jan	DE	A1	NotReceived
Feb	DE	A1	Distributed
Feb	DE	A1	Distributed
Feb	DE	A1	Distributed
Feb	DE	A1	Distributed
Feb	DE	A1	Distributed
Feb	DE	A1	Received
Feb	DE	A1	Received
Feb	DE	A1	Received
Feb	DE	A1	Received
Feb	DE	A1	NotReceived

I have various months, customers and countries.

The process flow is that every product is first DISTRIBUTED and then it can be RECEIVED or NOTRECEIVED by the client  ( TOTAL Distributed = RECEIVED+NOTRECEIVED).

What i want to extract (and show thru visualizations) is the percentage  of RECEIVED or NOTRECEIVED from DISTRIBUTED per each month.

The visualization will look like a cluster graph spread per month and in each month you will see the % of each or the two variables (RECEIVED and NOTRECEIVED) along with a slicer per customer.

Now, I assume a have to create a calculated column using DAX to SUM(DISTRIBUTED) and divide RECEIVED and NOT RECEIVED but i dont know how to write it properly.

My level in pbi is novice and I kindly need your help in order to get out of this tunnel vision I have.

thank you and stay safe.

[amitchandak]

Try a new measure like

divide(
calculate(countrows(filter(table[Logistic]<>"Distributed"))),
calculate(countrows(filter(table[Logistic]="Distributed")))
)

[Anonymous]

Thank you, I get: Too few arguments were passed to the FILTER function. The minimum argument count for the function is 2. 😞

[amitchandak]

@Anonymous , try like

divide(
calculate(countrows(filter(table,table[Logistic]<>"Distributed"))),
calculate(countrows(filter(table,table[Logistic]="Distributed")))
)

[Anonymous]

Thank you again @amitchandak ,

I get in return a blank column

[amitchandak · Accepted solution]

@Anonymous , I said for Measure, You are creating a column.

[Mariusz]

Hi @Anonymous 

The measure will look something like.

Measure = 
DIVIDE(
    CALCULATE( 
        COUNTROWS( 'Table' ),
        'Table'[Logistic] = "Distributed"
    ),
    CALCULATE( 
        COUNTROWS( 'Table' ),
        'Table'[Logistic] IN { "NotReceived", "Received" }
    )
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Thank you @Mariusz ,

The provided calculation returns a column filled with "1" (or100% if I formate it to %).

is this correct?

[Mariusz]

Hi @Anonymous 

The sample that you provided returns 5 records for "Distributed" and 5 records between 

"NotReceived" and  "Received" for both months, so the result will 5/5 this will return 1 or 100% for each month.

Hope this helps

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn