Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the follwing graph created with 1 Measure and 2 Dimensions
Measure
Percentage of Clients
Count(
{< [Money]={">0"}>}
distinct CLientNumber)
/
Count(
{< [IMoney]={">0"}>}
distinct TOTAL CLientNumber)
Dimesion Money Rounded to 50
Round ([MONEY],50)
Dimension Store.
StoreName
The problem I have with that, is that there could be Clients that have paid 50 Euros, but also 80 Euros as well. This makes the Expression to fail, when calculanting this...
Count(
{< [IMoney]={">0"}>}
distinct TOTAL CLientNumber)
The formula (Above in Red) only counts the client One Time, and then the sum of the Percentages that comes from the Dimension Money sums more than 100%.
What I need?
- Percentage of Clients sums 100% for a particular shop, that is the sums of for every MONEY range percentage.
- Preferable solution is that the Dimension, does not work for they MONEY payed in different transactions, rather than that for the SUM of all transactions for every client.
A jobmate has gave me the solution.
Round (Aggr(sum[MONEY],ClientNumber),50)
May be try this
Count({<[IMoney]={">0"}>}DISTINCT TOTAL <Money> CLientNumber)
I didn´t work, still causes to not sums 100%, and sums more.
How about this
Aggr(NODISTINCT Count({<[IMoney]={">0"}>}DISTINCT CLientNumber), Money)
I get NULL values with that expression.
A jobmate has gave me the solution.
Round (Aggr(sum[MONEY],ClientNumber),50)