Forum Discussion

IMORTC's avatar
IMORTC
Regular Visitor
8 years ago
Solved

Fixed value for % ratios

How do I calculate a fixed measure based on a fixed filter like for example below. I need the base turnover calculation to be able to calculate % ratios.   Basically what I need is the field "2_tes...
IMORTC's avatar
IMORTC
Regular Visitor
8 years ago

Thank you for prompt help :) That did the trick!

 

 

IMORTC's avatar
IMORTC
Regular Visitor
8 years ago

Another issue has come up... and I am pretty stuck here....

 

The previous offered solution works like a charm, when you apply the slicers individually. However if I pick two members in the slicer, see below, then it seem to double my ACT figures whereas only calcing the % ratio on one member... pls see below:

 

Correct view with one member selected in slicer:

 

 

When picking multiple members in the slicer it shows eg 200% in the % column:

 

 

My DAX code for the PCT columns look like this:

 

% = [Actuals - Period]/CALCULATE(SUM('FCC Data'[Actuals - Period]);FILTER(ALLEXCEPT('FCC Data';'FCC Data'[Calendar];'FCC Data'[AM];'FCC Data'[Country]);'FCC Data'[AccountRetail]="Turnover"))

  • ricardocamargos's avatar
    ricardocamargos
    Icon for Continued Contributor rankContinued Contributor
    8 years ago

    Hi IMORTC,

     

    How do you relate the members with the data ?

     

    Thanks,

     

    Ricardo

    • IMORTC's avatar
      IMORTC
      Regular Visitor
      8 years ago

      Hi Ricardo,

       

      Thx for your help! They are related in the same table... see below:

       

       

       

      • ricardocamargos's avatar
        ricardocamargos
        Icon for Continued Contributor rankContinued Contributor
        8 years ago

        IMORTC,

         

        Can you provide a sample dataset ?

         

        Thanks,

         

        Ricardo