issue while calculating % of total on matrix value

[Anonymous]

Hey Everyone,

I'm new to Power BI, i need some help.

I'm trying to populate

Avg Transaction LC = Total Sales / total transaction

for last 12 month here is formula

Avg Transaction LC Last 12 Months:=CALCULATE (
[Avg Transaction LC],
DATESINPERIOD ( 'date'[Date], MAX ( 'date'[Date] ), -12, MONTH )
, ALL('date')
)

but the values in table matrix should not be greater than 100% as shown in green highlighted in below image.

Onething i want to add here simple sales amount or no of transactions are working fine even if i want to see % of total it's working 100% ok. but in case of Avg Transaction Value matrix expected behaviour is not as it is in simple measure... I only dividing two measures. Not getting why it's behaving like this.

Help will be appreciated.

Thanks

[amitchandak]

@Anonymous , I assuming Total sales and Total transaction are measure and formula is like this

Avg Transaction LC = divide([Total Sales],[total transaction])

Try this without all date

Avg Transaction LC Last 12 Months:=CALCULATE (
[Avg Transaction LC],
DATESINPERIOD ( 'date'[Date], MAX ( 'date'[Date] ), -12, MONTH )
)

[Anonymous]

@amitchandak 

Yes you are correct both are measures.

And i've tried by removing all dates from measure ... still same behaviour

[v-xuding-msft]

Hi @Anonymous ,

Have you resolved it? Does the answer make sense?

[v-xuding-msft]

Hi @Anonymous ,

Can I ask why you show values as percentage of column total? Do you just want to show percentage format of the measure result?If so, you could click the measure and choose percentage as image shown.

The option of  show values as percentage of column total means :

% =
DIVIDE (
    [Avg Transaction LC Last 12 Months],
    CALCULATE (
        [Avg Transaction LC Last 12 Months],
        ALLSELECTED ( 'table'[Tenant Name] )
    )
)

If you still can't resolve it, please share some sample data and expected output. We will understand more clearly.