Forum Discussion

chetan8080's avatar
chetan8080
Icon for Helper II rankHelper II
4 years ago
Solved

Change fields in slicers using DAX

Hello Power BI Family!
I have a dataset which has a column named "value" which is used in all the dax calculations in the dashboard,
But!! I need a Dax that will make use of another column called "Carset value" in all daxes  based upon a slicer selection in dashboard.

Thank you in Advance
From,
Crescenza Consulting Pvt Ltd.

  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, chetan8080 

     

    There is a situation that fits your needs better.

    Data Format:

    At this point it is possible to select the value you want to calculate through the slicer.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

6 Replies

  • Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?  Note that slicers need to be fed by columns, they cannot be fed by measures.

    • chetan8080's avatar
      chetan8080
      Icon for Helper II rankHelper II

      These are two columns which i have used in all Dax measures 
      Ex: 

      We have alot of other DAX which has this "Value" column used.
      I am searching for a new Dax used as a slicer that will on filtering use column "Carset value" in all the Daxes and do the calculations . Is it possible ?
      Thank you lbendlin  for your response!

      • v-zhangti's avatar
        v-zhangti
        Icon for Community Support rankCommunity Support

        Hi, chetan8080 

         

        There is a situation that fits your needs better.

        Data Format:

        At this point it is possible to select the value you want to calculate through the slicer.

         

        Best Regards,

        Community Support Team _Charlotte

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

         

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support

    Hi, chetan8080 

     

    Can you provide some sample data? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.