Calculate several numeric values

Question

Hi guys,&nbsp;I need to calculate values like the following:&nbsp;&nbsp;PlanFactNew measure&nbsp;15&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;151515&nbsp;15&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;Total1801515&nbsp;I almost done this with&nbsp;Matrix plan = if(not(ISBLANK([Fact]));'Local Measure'[Plan];blank()) but it shows me wrong value in totals (still 180 instead of 15).&nbsp;Plan and Fact values from different tables. Both tables - live and already calculated data.&nbsp;&nbsp;Is that possbile to do?

zubair_muhammad · Answer

HI idontexist&nbsp;Try adding if hasonevalue before your MEASURE&nbsp;If(hasoneValue(LocalMEasure[Plan]), YourMEASURE)

idontexist · Answer

Hi&nbsp;Zubair_Muhammad&nbsp;But if value is not only one? It could be several values.

zubair_muhammad · Answer

idontexist&nbsp;is the Plan Column aggregated in some way?

idontexist · Answer

Zubair_Muhammad&nbsp;It's plan for store for all days in month. &nbsp;Table "plan" contains 3 columns: date, store code and value. Value already calculated before downloading in live cube, so it's just number.

v-jiascu-msft · Answer

Hi&nbsp;idontexist,&nbsp;Can you share the pbix file please? The relationship between two tables could affect the result.&nbsp;Best Regards,Dale

Forum Discussion

Calculate several numeric values

9 Replies

Related content

Calculated column to assign numeric code to dates

Slicer for filtering several columns

Average calculation with several conditions

Calculating average between several columns

Calculate percent columns by several tables

	Plan	Fact	New measure
	15
	15
	15
	15
	15	15	15
	15
	15
	15
	15
	15
	15
	15
Total	180	15	15