Forum Discussion

jmkvalsund's avatar
jmkvalsund
Icon for Helper III rankHelper III
2 years ago
Solved

Measure returning data only when using smaller than operator

There might be an obvious solution for this topic, but I just dont see it:   I have a datasource looking like this: CustomerID OrderDateID CAM 123456 20231215 CAM1 123457 20240...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi jmkvalsund ,

    Firstly thanks to Ashish_Mathur  and lbendlin  for their prompt replies, I created some sample data to solve the problem for you. You can follow the steps below:

    1. Modify your measure.

    M_NumberOfNewCustomersByCAMThisYear =
VAR var_M_LastDatePreviousYear = [M_LastDatePreviousYear]
VAR M_SelectedUser =
    SELECTEDVALUE ( Customers[CAM] )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( Customers[CustomerID] ),
        FILTER (
            Customers,
            CALCULATE ( MIN ( Customers[OrderDateID] ) ) > var_M_LastDatePreviousYear
        )
    )

    2.Add a Slicer.

     

    Final output:
    Count all CAM when OrderDateID > 20231229

    Count CAM1 when OrderDateID > 20231229

    How to Get Your Question Answered Quickly - Microsoft Fabric Community

    If it does not help, please provide more details with your desired out put and pbix file without privacy information.

     

    Best Regards,

    Ada Wang

    If this 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
2 years 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 or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523