Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Change static value in caluculate filter

Hi all,   I have a problem with my power BI and i can't seemt to get the calculation to work. I've made the calculation:   UnderProkura KR = Calculate(SUM([Produceret Omsætning]);Data[Producere...
Need Help
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    Write correct column in Power BI Desktop

    UnderProkura KR = Calculate(SUM([Produceret Omsætning]);Data[Produceret omsætning 2]<4000)

    ->

    UnderProkura KR =
CALCULATE (
    SUM ( [Produceret Omsætning] ),
    FILTER ( Data, Data[Produceret omsætning 2] < 4000 )
)
    Prokuragrænse =
    if(Data[Kundenavn]="Customer 1";4000)
    & if(Data[Kundenavn]="Customer 2";5000)
    & if(Data[Kundenavn]="Customer 3";10000)
    ->
    Prokuragrænse =
SWITCH (
    Data[Kundenavn],
    "Customer 1", 4000,
    "Customer 2", 5000,
    "Customer 3", 10000
)
    Best Regards
    Maggie
     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous 

Write correct column in Power BI Desktop

UnderProkura KR = Calculate(SUM([Produceret Omsætning]);Data[Produceret omsætning 2]<4000)

->

UnderProkura KR =
CALCULATE (
    SUM ( [Produceret Omsætning] ),
    FILTER ( Data, Data[Produceret omsætning 2] < 4000 )
)
Prokuragrænse =
if(Data[Kundenavn]="Customer 1";4000)
& if(Data[Kundenavn]="Customer 2";5000)
& if(Data[Kundenavn]="Customer 3";10000)
->
Prokuragrænse =
SWITCH (
    Data[Kundenavn],
    "Customer 1", 4000,
    "Customer 2", 5000,
    "Customer 3", 10000
)
Best Regards
Maggie
 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Maggie,

     

    Thank you  - it worked perfectly! :)

     

    Best regards

    Rasmus