Forum Discussion

Marango's avatar
Marango
Regular Visitor
1 year ago
Solved

create measures with filters

Hello, I need to create measures using some filter to be able to make some card visuals.   here is what I did: I have my date base with all years information, so for making the "sales per year"  ...
Filters
Measures
powerbi
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thank you lbendlin for your concern.

     

    Hi Marango ,

     

    Based on your description I created simple data:

     

    You can refer to the following measures to get positive and negative totals:

     

    increasing measure = CALCULATE([Measure],FILTER('Table',[Measure]>0))
    lost measure = CALCULATE([Measure],FILTER('Table',[Measure]<0))

     

     

    Result:

     

    Best Regards,
    Zhu

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523