Dax and model help

[Balhemkan]

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 

[Anonymous]

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?

[Balhemkan]

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

[Anonymous · Accepted solution]

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