Forum Discussion

irfanelevated's avatar
irfanelevated
Icon for Helper II rankHelper II
5 years ago
Solved

Filter not working on measure field

Hello,   I am new to PowerBI, created a measure field - Measure = CALCULATE(SUM(Orders[Sales]), Orders[Sub-Category]="Phones")   Then I have added sub-category as slicer and selected any other ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Try this

    Measure = CALCULATE(SUM(Orders[Sales]),FILTER(Orders,Orders[Sub-Category]="Phones"))+0

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Try this

Measure = CALCULATE(SUM(Orders[Sales]),FILTER(Orders,Orders[Sub-Category]="Phones"))+0

Hope this helps.