Forum Discussion
Working with filters in measures
Hi, Anonymous
If I understand you correctly, you can create a measure and drag it to visual filter pane as follows:
Measure1 = VAR a = CALCULATE ( SUM ( Sheet1[Billed Amount] ), ALLEXCEPT ( Sheet1, Sheet1[Client ] ) ) RETURN IF ( a > 10000, 1, 0 )Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi, Anonymous
If it is convenient, please show some relevant screenshots or your current file.
Do you have other filters/slicers to apply to this visual?
The measure I created is only uesed to filter the rows that meet the conditions in the original table, and will not affect the value of Billed Amount. In addition, please check whether the fields used in your matrix are consistent with mine.
Best Regards,
Community Support Team _ Eason
Super UserAnonymous , Try a measure like
Measure =
var _1 = calculate(sum('Sheet1'[Billed Amount]) ,filter('Sheet1', 'Sheet1'[Client] = max('Sheet1'[Client])))
return
sumx(filter( values('Sheet1'[Client]), _1 >10000), calculate(sum('Sheet1'[Billed Amount])))
amitchandak , this measure does the same as the one I have.. Is there a way to have all sites to be there as long as account adds up to more than 10K.
Like the value for Sites should be seen as long as the accounts add up to more than 10K..Let me show you what it brings.As you can see the sites like for client B,and New York site shows 13K..
- v-easonf-msft
Community Support
Hi, Anonymous
If I understand you correctly, you can create a measure and drag it to visual filter pane as follows:
Measure1 = VAR a = CALCULATE ( SUM ( Sheet1[Billed Amount] ), ALLEXCEPT ( Sheet1, Sheet1[Client ] ) ) RETURN IF ( a > 10000, 1, 0 )Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.v-easonf-msft , thanks. From the solution, I can see the table is okay but I get a different table when I apply the same. Don't know why.
Does the table created impact on anything?
- v-easonf-msft
Hi, Anonymous
Could you please tell me whether your problem has been solved?
If you still need help, please share more details.
If it is solved, you could share your solution here and accept it as solution to close this thread.
Best Regards,
Community Support Team _ EasonTHanks v-easonf-msft