Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Display diff values for diff rows

heading sub heading value h1 sub1   h1 sub2     here need to display values under the value column but sub1 caluculation is diff and sub2 caluculation is diff. i tried if(table[s...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    "sub1 caluculation is diff and sub2 caluculation is diff" -- I have difficult to understand this part. Both the calculation of sub1 and sub2 are diff? What is this "diff"?

    Just look at your measure, maybe you can try the following formula.

    measure = switch(selectedvalue(sub heading),"sub1",[measure],"sub2",[measure2],...)

    https://docs.microsoft.com/en-us/dax/switch-function-dax 

    If I misunderstand your requirement, please share some sample data and expected result to us.

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

"sub1 caluculation is diff and sub2 caluculation is diff" -- I have difficult to understand this part. Both the calculation of sub1 and sub2 are diff? What is this "diff"?

Just look at your measure, maybe you can try the following formula.

measure = switch(selectedvalue(sub heading),"sub1",[measure],"sub2",[measure2],...)

https://docs.microsoft.com/en-us/dax/switch-function-dax 

If I misunderstand your requirement, please share some sample data and expected result to us.

 

Best Regards,

Jay