Day wise Percentage of Pool

[DarshanPatel24]

Hello 

i have one table & i want to find out Percentage of pool BSNL for 1st May .

eg,

% BSNL for 1st May = Call value of BSNL For 1st May / Total Call value of BSNL .

Please help me with Formula !

Date	Pool	Call Value
5/12/2019	BSNL	100
5/1/2019	VODA	30
5/1/2019	AIRTEL	50
5/1/2019	AIRTEL	70
5/1/2019	BSNL	60
5/19/2019	VODA	20
5/19/2019	BSNL	120
5/19/2019	VODA	100
5/1/2019	BSNL	100
5/19/2019	AIRTEL	120
5/5/2019	AIRTEL	20
5/1/2019	AIRTEL	100
5/1/2019	BSNL	180
5/12/2019	VODA	190
5/1/2019	VODA	60

[Nathaniel_C]

Hi @DarshanPatel24 ,

Try this:
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

First of May =
VAR _date =
    DATE ( 2019, 5, 1 )
VAR _Pool = "BSNL"
VAR _calc =
    CALCULATE (
        [Call Value Total],
        callValue[Pool] = _Pool,
        callValue[Date] = _date
    )
VAR _calc2 =
    CALCULATE ( [Call Value Total], callValue[Pool] = _Pool )
VAR _percentage =
    DIVIDE ( _calc, _calc2 )
RETURN
    _percentage