Forum Discussion

idontexist's avatar
idontexist
Icon for Helper I rankHelper I
8 years ago

Repeat values based on other value

Hi all,   I want to repeat values as you can see in column "should be plan". It should be based on column "Fact". If in this column there are any values so plan should be repeated. "Plan" i have 1 ...
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi idontexist

 

Try this MEASURE.

It works with your sample data

 

Measure =
VAR FirstValue =
    CALCULATE (
        VALUES ( TableName[Plan] ),
        FILTER (
            ALL ( Tablename ),
            MONTH ( TableName[Date] ) = MONTH ( VALUES ( TableName[Date] ) )
                && TableName[Date]
                    = MINX (
                        FILTER (
                            ALL ( TableName ),
                            MONTH ( TableName[Date] ) = MONTH ( VALUES ( TableName[Date] ) )
                        ),
                        TableName[Date]
                    )
        )
    )
RETURN
    IF ( NOT ( ISBLANK ( SELECTEDVALUE ( TableName[Fact] ) ) ), FirstValue )
idontexist's avatar
idontexist
Icon for Helper I rankHelper I
8 years ago

Hi Zubair_Muhammad

 

It return me an error. Words in Russian could be translated as "Error during calculating measure...".

 

 

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Hi idontexist

     

    Please try replacing

     

    VALUES (Local Measure[Measure Quantity])

     

    with

     

    SUM (Local Measure[Measure Quantity])