Forum Discussion
Syndicate_Admin
Administrator
AdministratorTop N with static values
Hello I have a table of dimensions with the attributes of a product, and another table (of dimensions too) with the warehouses where it is sold. It is required to initially generate a top of ...
Hi Syndicate_Admin ,
I created some data:
You can use tabs to display:
Here are the steps you can follow：
1. Create measure.
VALOR_INICIAL_TOP_N_ORIG = var _Table=SUMMARIZE(ALL('Table'),'Table'[Product],"Total",SUM('Table'[Value])) var _TOP_TABLA=TOPN(3,_Table,[Total],DESC) return IF( MAX('Table'[Product]) in SELECTCOLUMNS(_TOP_TABLA,"1",[Product]), 1,0)2. Place [VALOR_INICIAL_TOP_N_ORIG]in Filters, set is=1, apply filter.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Syndicate_Admin ,
I created some data:
You can use tabs to display:
Here are the steps you can follow：
1. Create measure.
VALOR_INICIAL_TOP_N_ORIG =
var _Table=SUMMARIZE(ALL('Table'),'Table'[Product],"Total",SUM('Table'[Value]))
var _TOP_TABLA=TOPN(3,_Table,[Total],DESC)
return
IF(
MAX('Table'[Product]) in SELECTCOLUMNS(_TOP_TABLA,"1",[Product]),
1,0)
2. Place [VALOR_INICIAL_TOP_N_ORIG]in Filters, set is=1, apply filter.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly