Different value at granular level and aggregated level

[atult]

Hello experts,
We have data at manufacturer and keyword level. I require Share of search(SOS) and weighted share of search(Wtd SOS) which i have successfully calculated.

Where I’m facing issue is i need to show the calculated Wtd SOS at keyword level whereas need to show SUM(Wtd SOS) / SUM(Weights) at aggregated level.

Can someone please help me with the DAX so that i can achieve the above in a single calculated measure?

Data and Expected output (Light green cells at keyword level whereas dark green cell value in aggregated view in card/bar/line):

Data in table:

Manufacturer	Keyword	Value	Weights
MW1	abc	10	0.01
MW1	xyz	20	0.02
MW2	pqr	30	0.03
MW2	def	40	0.07

@amitchandak , @lbendlin , @Ritaf1983 , @Ahmedx , @Idrissshatila , @parry2k 

[v-binbinyu-msft · Accepted solution]

Hi @atult ,

Please try to create measure with below dax formula:

Measure =
VAR _a =
    SELECTEDVALUE ( 'Table'[Weights] )
VAR _b =
    SELECTEDVALUE ( 'Table'[SOS] )
VAR _c = _a * _b
RETURN
    _c

Measure2 =
VAR _a =
    SUMX ( 'Table', [Weights] )
VAR _b =
    SUMX ( 'Table', [Measure] )
RETURN
    IF ( ISINSCOPE ( 'Table'[Manufacturer] ), _b, DIVIDE ( _b, _a ) )

Add a table visual with fields and measure:

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@atult here is the link to the videos:

Let's explore the underrated ISINSCOPE DAX function - What is it? How we can use it? - YouTube

ISINSCOPE & ISFILTERED DAX functions give the same result-learn why use one over another- Power BI -...

Improve matrix visual by using calculation groups, conditional formatting, and ISINSCOPE - Power BI ...

[parry2k]

I have few videos in this function on my YouTube channel - YouTube.com/@PowerBIHowTo

[parry2k]

@atult @You can use isinscope function to control the calculation.