Forum Discussion

shreyas7019's avatar
shreyas7019
Frequent Visitor
1 year ago

Power BI Desktop Measure not filtering raw data in below table

I have created a query with multiple left join and bought it into Power Bi . Now i have created several measures and added it into a funnel chart . This is one one my measures

New MOP was provided =
CALCULATE(
    DISTINCTCOUNT('Payment Upon Install SA'[SA-Id]),
    FILTER(
        'Payment Upon Install SA',
        'Payment Upon Install SA'[bt_stripe__Transaction_Status__c]="Failed" &&
        'Payment Upon Install SA'[PaymentCreatedDate] = 'Payment Upon Install SA'[SA-Arrival_Window_Start_Actual__c]
    )

)
Now i have a raw data in a table below , but when i press my measure it does not filter the raw data . Could you please help me with this.
Thanks in advance.
Show and Tell

3 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Icon for Super User rankSuper User
    1 year ago

    Hi shreyas7019 -You can create a calculated column to tag rows in your table that meet the criteria specified in your measure. 

     

    IsNewMOPProvided =
    IF(
    'Payment Upon Install SA'[bt_stripe__Transaction_Status__c] = "Failed" &&
    'Payment Upon Install SA'[PaymentCreatedDate] = 'Payment Upon Install SA'[SA-Arrival_Window_Start_Actual__c],
    "Yes",
    "No"
    )

     

    Use this column in your table visual as a filter by setting it to "Yes."

     

    Hope this works, please check.

    • shreyas7019's avatar
      shreyas7019
      Frequent Visitor
      1 year ago

      Hey rajendraongole1  , thanks for the solution but in my funnel there are mutliple measure , if i use this method it will only filter out that data , i want to be able to make it dynamic for other measures too . Hope i get a solution for this . Thank you

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, shreyas7019 

    Thanks for rajendraongole1's reply. Have you currently solved the problem, if not, you can share the pbix file without sensitive data for testing purposes, this will help you solve the problem faster.

    Best Regards,
    Yang
    Community Support Team