how to show default KPI value using DAX

[SandySharma]

HI Gurus,

I got stuck during the development of my dashboards in power BI. I am new to power BI , my query might be silly but I could not figureout how to do the same, that's why I am approaching Gurus here, so excue for the same.

Requirement: I have two Chart one Bar chart and second Card Chart. in Card chart I want to show default value of any dimension displayed in Bar chart by default instead aggregation of all.

As you can see in above screen shot Card is showing aggreated value.

Requirement: Instead of all, I want to display the default value of first dimension visible in bar chart however user should be able to select any of dimension from Bar chart and value should be change accordingly.

Please help me how can I achieve the same in Power BI.

[MFelix]

Hi @SandySharma,

I don't know how you are calculating the Numeric Market Growth but in my example I have made a simple table with Country and Values

Made a simple measure to calculate the % per country:

% Total =
MAXX (
    Table1,
    Table1[Values] / CALCULATE ( SUM ( Table1[Values] ), ALL ( Table1 ) )
)

You need to wrap your measure in a MAXX formual something like this:

Number Market Share_Max = MAXX(Data,[Number Market Growth])

Should make the trick.

Regards,

MFelix

[SandySharma · Accepted solution]

Hi MFelix,

My Requirement was littel different. If no interaction is happening then it Card should show the value of North Asia, If any ineraction happened on Bar Chart then it should show the selected value result in card from Bar chart.

After few hit and trail I am able to do the same by taking reference from DAX HASONEFILTER Function (DAX)

My Logic :

Measure 2 = IF(HASONEFILTER(Data[Geo]),ROUND( (SUM(Data[Market Growth])*100),1)&"%" &"("& FILTERS(Data[Geo])&")",
CALCULATE(ROUND( (SUM(Data[Market Growth])*100),1) &"% (North Asia)",Data[Geo]="North Asia"))

No interaction in above chart and able to show Default value of North Asia.

interaction happen on bar chart and selected DVM in above chart and able to show DVM Value.

Anyways thanks for your effort.