Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys!
I have an expression:
if( Sum([ABC_SUM]) / Sum(total <ABC_REGION, ABC_INDUSTRY>[ABC_SUM]) >= 0.8, 'A',
if( Sum([ABC_SUM]) / Sum(total <ABC_REGION, ABC_INDUSTRY>[ABC_SUM]) >= 0.5, 'B', 'C'))
But here the problem: I can't convert the expression to dimension so that I could use it for Filter or for Dimesion in the table.
Could you please help me?
Or may be there is the way to write something like this expression in the script?
Thanks a lot in advance!
I found the answer. I modified my script and solved the issue:
Try the below as calculated dimension.
=Aggr(if(Sum([ABC_SUM]) / Sum(total <ABC_REGION, ABC_INDUSTRY>[ABC_SUM]) >= 0.8, 'A',
if( Sum([ABC_SUM]) / Sum(total <ABC_REGION, ABC_INDUSTRY>[ABC_SUM]) >= 0.5, 'B', 'C')), ABC_REGION, ABC_INDUSTRY)
Hi! Thanks for the answer, but result is 'A' in every row.
To create a measure into dimension you need a relative dimension to aggregate on,
like if you have three fields,
Category,State,Sales
If you want your measure Sum(Sales) to be a Dimesnion you need to aggregate it to either of the fields, but aggregating in on Sales will just give you Sales value. So better to aggregate it on Category,State.
Try:-
Aggr(
if( Sum([ABC_SUM]) / Sum(total <ABC_REGION, ABC_INDUSTRY>[ABC_SUM]) >= 0.8, 'A',
if( Sum([ABC_SUM]) / Sum(total <ABC_REGION, ABC_INDUSTRY>[ABC_SUM]) >= 0.5, 'B', 'C'))
,Your_Neccessary_Dimension).
Remeber Aggregates work like you are joining a table using group by column, Those Group by Columns are 'Your_Neccessary_Dimension'.
Hi! Thanks for the answer. Previous answer was the same. Unfortunately I tried to make like this, but it doesn't work. Always shows an 'A' in every row.
I found the answer. I modified my script and solved the issue: