Forum Discussion
Dax and model help
Hi Team,
Please help me with issue.
In Dim Business type we have values like A B C
In fact business type we have values like A B C
When ever we select A Or B it should show total of A B C.
When ever we select C we should get only C total.
Now when we select A it showing only A total instead of A B C. Please help me i stuck with these from two days
Kindly find the sample data along with detial requirement
https://drive.google.com/file/d/1IAc5Ux2R_0QbfBe_6EG2JlI_4nGtHRgv/view?usp=drivesdk
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
3 Replies
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
