Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Balhemkan
Helper III
Helper III

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 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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

Anonymous
Not applicable

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.