Forum Discussion

brunofds's avatar
brunofds
Icon for Helper I rankHelper I
3 years ago

Unusual QUARTERS - DAX

Hello there. Dealing with a problem here in my dataset.     For the sake of simplicity, I have a simple database with DimDate (from jan.1 to December 31) and FactOrders, using NorthWindDataset for ...
Need Help
brunofds's avatar
brunofds
Icon for Helper I rankHelper I
3 years ago

I'm not complete aware on how to solve this...

 

Using the example above mentioned (https://easyupload.io/ianzro) , how can I turn the "average quarter" into the "correct" result, which is: 

50+ 100 + 40

/ 3  

 

 = 63,33333333333333‬

 

 

 

or the sum of amount (Amount_ measure_)  into 190?

 

I'm aware of the filters and whats wrong here, but not sure how to solve it.

 

Thanks

 

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
3 years ago

There could be different ways to solve it but the best way left is to share a sample of your pbix.