Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Measures need to replace by Table joins

i have to replace a meaure with table which is like below   measure= if (sum(Total)=5, 2.33, if(sum(Total)=6,4.99, if(sum(Total)=9,8.33.......) continues...... i have above set of statements which...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

No it is not working

i created another table named as Test which has columns Total, Value...i joined both fact and text on Total....i'm able to see values....

 

My query is Measure consisting SUM, how we can tackle that

  • rajulshah's avatar
    rajulshah
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Anonymous I am still not able to understand the issue. Can you please elaborate?