Forum Discussion

arulsettu's avatar
arulsettu
Frequent Visitor
9 years ago

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])...
Need Help
arulsettu's avatar
arulsettu
Frequent Visitor
9 years ago

i am using this as dimension

 

CALCULATE(MAX([end_time].[Date]),ALLEXCEPT('table_name',[Year]))

 

and 

 

count(value)

 

so where and what should i add as anew column

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi arulsettu,

 

You should add a index column to let the measure calculate loop the table.

 

For example:

 

 

Notice: Count(value) will summarize this field

 

Regards,

Xiaoxin sheng

  • arulsettu's avatar
    arulsettu
    Frequent Visitor
    9 years ago

    i am doinglike below is this correct

     

    Thanks