Forum Discussion

Icon for Post Prodigy rank

Post Prodigy

11 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

Praful_Potphode
11 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

Praful_Potphode

Icon for Super User rank

Super User

11 months ago

Try Below Measure:

# DC_Filter = 
CALCULATE(
    COUNTROWS('ontvangen'),
    FILTER(
        'ontvangen',
        [Filter DC] = TRUE()
    )
)

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

Frixel
Post Prodigy
11 months ago
yes i can create that measure but when i then create the filter in ....ontvangen then this error.
And the 'From' is not inserted by power bi but by myself.
- Praful_Potphode
  Super User
  11 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