Forum Discussion

abhaygawde's avatar
abhaygawde
Frequent Visitor
9 years ago

write DAX formula to return table

Can any one help to write DAX formula that will return table single column value dynamicallly base on switch case? If in slicer i chose filter value A then show record from A table and if i filter B...
Need Help
BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
9 years ago

Your explanation of the topic is too vague. We would like to see the data  with the expected output before proceeding ahead.

 

Can use HASONEVALUE function as well.

abhaygawde's avatar
abhaygawde
Frequent Visitor
9 years ago

X- AxisY AxisData model

Hi Bhavesh ,

 

Basically i have one requirement where i have 2 use measure as a axis.

I have 2 slicer X-Axis and Y-Axis . If i filter Business Group from X slicer and Actual Revenue from Y slicer then graph should Plot where X- axis values is from Bussiness group table and and Y- axis values from Acutal Revenue table.

 

Any help will be appriciated.

 

Thanks And Regards,

Abhay