cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abhi123 Frequent Visitor
Frequent Visitor

Dax

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.

1 REPLY 1
Microsoft v-ljerr-msft
Microsoft

Re: Dax

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.Smiley Happy

 

Regards

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,448)