Forum Discussion

nanacobsbs's avatar
nanacobsbs
Helper I
3 years ago
Solved

Dax Command for filtered value

There are 3 filters Plant, Machine type and Machine No in a page. Currently, the graphs below show the total factory value and is not filtered. How can I use the DAX function to display filtered va...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi nanacobsbs ,

     

    As I understand it, your *Machine Type Filter and *Machine No. Filter can't be used at the same time, right? Otherwise, the two logics will cause conflict.

    If not, please provide more details. If possible, please provide the expected result in tabular form, such as what you chose in the slicer, and then show me the expected result in tabular form.

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

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

  • nanacobsbs's avatar
    nanacobsbs
    3 years ago

    Thank you for your comment.
    Regarding this question, I was able to solve it with the TREATAS function.

    I appreciate your offer of assistance.

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi nanacobsbs ,

     

    Really happy to hear that you've solved your problem.

    Please Accept the reply as the solution to help the other members find the useful information/ solution more quickly.  

                                                                                                                                                             

    Best Regards,

    Stephen Tao