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 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 

 

 

 

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

     

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

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

     

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

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    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'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