Forum Discussion
Fixed in power bi
HI, I am very new to power bi. acutally i am trying to convert TABLEAU app into power bi. in a chart there is caluclated dimension created as below { FIXED [Year Week]: MAX([End Time])...
Hi,
I'm very new to tableau,
I'm migrated this form of tableau for Power BI
in a collum of table there is calculated dimension created as below
Vda Forn Cat
{ FIXED [Regiao IM], [Nome Fabricante], [Nome Categoria], [Mercado] : SUM([Vendas Valor])}
so to do this power bi i did as follows:
Metrics = CALCULATE([Vendas Valor Cat]; ALLEXCEPT(DIM_CATEGORIA_AGREG;DIM_CATEGORIA_AGREG[REGIAO_IM];DIM_CATEGORIA_AGREG[NOME_FABRICANTE];DIM_CATEGORIA_AGREG[NOME_CATEGORIA];DIM_CATEGORIA_AGREG[MERCADO]))