Forum Discussion
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[sub heading] = "sub1",[measure]) i tried this way but am not getting values, these values are coming from another table. how can i achieve it?
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
2 Replies
Hi Anonymous
Can you add a sample of your data? It's hard now to understand your data Model.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
BTW, you can write codes like this:
if(table[sub heading] = "sub1",[Measure 1], [Measure 2])
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
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
