Forum Discussion

harirao's avatar
harirao
Post Prodigy
6 years ago
Solved

Combining two Measure into one

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 co...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • harirao's avatar
    harirao
    6 years ago

    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's avatar
    Pragati11
    6 years ago

    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's avatar
harirao
Post Prodigy
6 years ago

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's avatar
Pragati11
Super User
6 years ago

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's avatar
    harirao
    Post Prodigy
    6 years ago

    Hi Pragati11 ,

    Thanks for the solution, its working fine.

    Regards,

    Hari