I want to divide a total by average of Exchange rates for specifc quarter. When I use the Dynamic slicer results in Card Visual it shows perfect Average number that I am expecting e.g. 6.78232, however as soon as I use the same Dynamic Measure in DAX as a divisor results are different. Minor difference though however I need exact results. Any logical or techincal flaw you guys can see here, any suggestions?
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.