Forum Discussion

Frixel's avatar
Frixel
Post Prodigy
9 months ago
Solved

Error in create measure for filter

Hello,   I try to make a filter for multiple filters(42) and create this measure but it gives this error. What is the problem? also created this     
Need Help
  • Praful_Potphode's avatar
    Praful_Potphode
    9 months ago

    Hi Frixel 

    you cant use a column directly in a measure like that.the formula that you have shown in screenshot will work for new column not new measure.

    try below :

    Filter DC= 
IF(
    MAX('ontvangen'[From] )="[email protected]",
    TRUE(),
    FALSE()
)
    Filter DC= 
IF(
    SELECTEDVALUE('ontvangen'[From] )="[email protected]",
    TRUE(),
    FALSE()
)

     

    Please give Kudos or mark it as solution once confirmed.

     

    Thanks and Regards,

    Praful

     

     

     

v-hjannapu's avatar
v-hjannapu
Community Support
8 months ago

Hi Frixel,

I would also take a moment to thank Praful_Potphode  , rohit1991  for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Regards,
Community Support Team.

v-hjannapu's avatar
v-hjannapu
Community Support
8 months ago

Hi Frixel,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


Regards,
Community Support Team.