Combining two Measure into one

[harirao]

Hi Team,

Required your assistance, I am working on  Matrix visualization, where i want to combine two calculated measure as mentioned:
Below are measures
Eg: 107/282= %6+wk 38%

I want to combine column 2&3 as new result, similar for 4&5, 6&7 respectively, tried to calculated but not getting correct result in above table you can see TEST measure.
Dax:

Test = IF(ISBLANK(CALCULATE(DISTINCTCOUNT(Query1[OpportunityId]),

FILTER(Query1, Query1[Visibility]="Not Visible"

))),0,

(CALCULATE(DISTINCTCOUNT(Query1[OpportunityId]),

FILTER(Query1, Query1[Visibility]="Not Visible"

))))

&"/"&

IF(ISBLANK(CALCULATE(DISTINCTCOUNT(Query1[OpportunityId]),

FILTER(Query1, Query1[Visibility]="Not Visible"

))),0,

(CALCULATE(DISTINCTCOUNT(Query1[OpportunityId]),

FILTER(Query1, Query1[Visibility]="Not Visible"

))))/Query1[%6week_1&2]

Looking for below result.

can somebody help to get this result.

Thanks & Regards,
Hari 

[harirao · Accepted solution]

Hi @Pragati11,

Not getting correct result.


Below Measure used for calculation
% 6+ weeks visibility = DIVIDE(Query1[%6week_3],Query1[%6week_1&2],0)

%6week_1&2 = CALCULATE(DISTINCTCOUNT(Query1[NxOpportunityIdentifier]), FILTER(Query1, Query1[actual_visibility_weeks]> 0))+CALCULATE(DISTINCTCOUNT(Query1[NxOpportunityIdentifier]), FILTER(Query1, Query1[0 visibility exclusions]= "No"),

FILTER(Query1, Query1[actual_visibility_weeks]= 0))

%6week_3 = CALCULATE(DISTINCTCOUNT(Query1[NxOpportunityIdentifier]), FILTER(Query1, Query1[actual_visibility_weeks]>=6))

Regards,
Hari 

[Pragati11]

HI @harirao ,

You can just Concatnate your both measures as follows:

>6 Week Visibility/Percentage = CONCATENATE([>6week_visibility], CONCATENATE(" / ", [%6 + 6 weeks_visibility]))

Please replace your correct measure names in the above dax.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[harirao · Accepted solution]

Hi @Pragati11,

Not getting correct result.


Below Measure used for calculation
% 6+ weeks visibility = DIVIDE(Query1[%6week_3],Query1[%6week_1&2],0)

%6week_1&2 = CALCULATE(DISTINCTCOUNT(Query1[NxOpportunityIdentifier]), FILTER(Query1, Query1[actual_visibility_weeks]> 0))+CALCULATE(DISTINCTCOUNT(Query1[NxOpportunityIdentifier]), FILTER(Query1, Query1[0 visibility exclusions]= "No"),

FILTER(Query1, Query1[actual_visibility_weeks]= 0))

%6week_3 = CALCULATE(DISTINCTCOUNT(Query1[NxOpportunityIdentifier]), FILTER(Query1, Query1[actual_visibility_weeks]>=6))

Regards,
Hari 

[Pragati11 · Accepted solution]

HI @harirao ,

Just modify the last DAX as follows and check:

>6 Week Visibility/Percentage = CONCATENATE([>6week_visibility], CONCATENATE(" / ", FORMAT([%6 + 6 weeks_visibility], "0.00%")))

Please replace your correct measure names in the above dax.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[harirao]

Hi @Pragati11 ,

Thanks for the solution, its working fine.

Regards,

Hari 

[amitchandak]

@harirao , if you wanted to show appended result then you can show like

Append = [measure1] & " / " & [measure2]