Dax

[abhi123]

Hi All,

As i am new to power BI. I have to make one measure which shows the MonthWise Sales without putting date into the values shelf.

Whatever the Measure we are going to create it will display the MonthWise Sales except "une" sale.

Thanks in Adv!!!!!...

Abhi.

[v-ljerr-msft]

Hi @abhi123,

If I understand you correctly, the formula to create the measure should be similar like below.

Measure =
CALCULATE (
    SUM ( 'YourTableName'[MonthWise Sales] ),
    FILTER ( ALL ( 'YourTableName' ), 'YourTableName'[columnName] <> "une" )
)

If that isn't the case, could you post your table structures with some sample data and your expected result? So that we can better assist on the issue.

Regards