Forum Discussion

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

Calculate several numeric values

Hi guys,   I need to calculate values like the following:     Plan Fact New measure   15       15       15       15       15 15 15   15       15   ...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

HI idontexist

 

Try adding if hasonevalue before your MEASURE

 

If(hasoneValue(LocalMEasure[Plan]), YourMEASURE)

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

    Hi Zubair_Muhammad

     

    But if value is not only one? It could be several values.

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

        Zubair_Muhammad

         

        It's plan for store for all days in month.  Table "plan" contains 3 columns: date, store code and value. Value already calculated before downloading in live cube, so it's just number.