Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

NEW PARAMETER PHASING

Hello,    I want to create a New Parameter that allows me to see what's the phasing according to the day of sales.    For example, we have 20 days of sales in a period so in 19 day we are suppose...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    You can try to create this slicer table first:

    SlicerTable = DISTINCT(SELECTCOLUMNS('Table',"Parameter",'Table'[Day of sales]))

    Then try this measure:

    Measure =
IF (
    MAX ( 'Table'[Day of sales] ) = SELECTEDVALUE ( SlicerTable[Parameter] ),
    SELECTEDVALUE ( SlicerTable[Parameter] ) / MAX ( 'Table'[Working days] ),
    BLANK ()
)

    When select one value in slicer, the result shows:

    Hope this helps.

     

    Best Regards,

    Giotto

v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi,

 

You can try to create this slicer table first:

SlicerTable = DISTINCT(SELECTCOLUMNS('Table',"Parameter",'Table'[Day of sales]))

Then try this measure:

Measure =
IF (
    MAX ( 'Table'[Day of sales] ) = SELECTEDVALUE ( SlicerTable[Parameter] ),
    SELECTEDVALUE ( SlicerTable[Parameter] ) / MAX ( 'Table'[Working days] ),
    BLANK ()
)

When select one value in slicer, the result shows:

Hope this helps.

 

Best Regards,

Giotto