Forum Discussion
Dax and model help
Hello!
I think i got it but it is kind of wierd... you want the filter A and B to not work haha
See if this helps you, doing this way, you can create any value or filter you want:
https://drive.google.com/file/d/1v1B5F3NYF04YeLfpmxIuoibn4QIfdwBW/view?usp=sharing
Hello Balhemkan,
Let me see if i understood... in your example, Ram have a total of 210 sales, 30 of type A, 70 of B and 110 from C.... with this example, if you filter on A and Ram, it will show just type A from Ram, totaling 30...
But on your question, you want to, when you click A (that filter A), you want to PBI shows you all types?? And when you click C to filter C, you want to really get only C??
Or do you want to create a category that if you press "A", pbi shows you the total amount of all types?
Hi Anonymous when you filter A in slicer. It should show sum of all category (A &B&C). Same way for B also.
But when we select C in filter we should get only C( sum of all C)
Exactly how you mentioned in second paragraph. Same way we want
Hello!
I think i got it but it is kind of wierd... you want the filter A and B to not work haha
See if this helps you, doing this way, you can create any value or filter you want:
https://drive.google.com/file/d/1v1B5F3NYF04YeLfpmxIuoibn4QIfdwBW/view?usp=sharing