Dax Command for filtered value

[nanacobsbs]

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 values?

*Separate Resource and Unit data tables are graphed and displayed on a single page.

*Machine Type Filter : When selecting a plant, I want to display only the MACHINE type that the plant has.

*Machine No. : I want to display only the machine No. associated with the MACHINE type of each plant. If all MACHINE No. are checked, I want to show the total value of all machines.

[Anonymous · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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