Forum Discussion

RichA08's avatar
RichA08
Frequent Visitor
1 year ago
Solved

Filter Columns in Matrix with a date hierarchy

HI!   I only want to see the items with a negative value in each month. The months are all part of 1 column due to it being a date hierarchy. When I filter the value, it is not applying to all the ...
Need Help
  • v-lgarikapat's avatar
    v-lgarikapat
    1 year ago

    Hi RichA08 ,

    Thanks for reaching out to the Microsoft fabric community forum.

    Ashish_Mathur , Bmejia 

    Thanks for your prompt response

    RichA08 , 

    Could you please provide sample data that fully represents the issue or question you're referring to? Kindly ensure the data is in a usable format ( Excel or CSV) rather than a screenshot, and does not contain any sensitive or unrelated information. 

    Looking forward to your response.

    Best regards,
    Lakshmi.

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

you need to use a If statement or switch statement so that you can declare anything below 0 will show 0 in your measure, measure column. or if you just dropping a value from a column then you need to do it using  a measure or measure column.
Example: you can selectvalue, sum, max not sure what your calculation is doing but should looks something like this.

Measure=
IF(
       SELECTEDVALUE(PurchaseOrdersAging[Aging])<=0 
       ,0
      ,SELECTEDVALUE(PurchaseOrdersAging[Aging])
       )