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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
satishk1511
Regular Visitor

Question on Dynamic Measure

Hi -
 
I have a question i am having a tough time figuring out the answer to..
 
Basically what i want to do is this. Suppose i have product sales at a monthly-store level like below. And i have a bunch of auxilary store measures like Squarefootage, what type of store, who is store manager etc..
 
Basically what i want to do is, when someone clicks on a Product from a filter, i need to know share of Sales for that product in that product type for the selected time period... More like market share for my Product, in example below, for selected time period (Month #1), My brand share is 20% , as my share is 20 / (20 + 30 + 50) for Product Type Apparel...(so i will want this # to be updated dynamically for any combination of filters the users may apply)
 
Please let me know and i will be forever grateful!
 
Example below
 
Product - Store - Sales - Month - Product Type - Brand
A               1           20         1            Apparel     - MyBrand
B               1           30         1            Apparel       Competitor Brand
C               1           50         1           Apparel         Competitor2 Brand
1 REPLY 1
Ashish_Mathur
Super User
Super User

Hi,

 

You have not shared enough data to think of a robut solution.  Try this measure

 

=SUM(Data[Sales])/CALCULATE(SUM(Data[Sales]),ALL(Data[Product]))

 

Select any product in the slicer/filter.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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