Calculate several numeric values

[idontexist]

Hi guys,

I need to calculate values like the following:

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

I almost done this with Matrix plan = if(not(ISBLANK([Fact]));'Local Measure'[Plan];blank()) but it shows me wrong value in totals (still 180 instead of 15).

Plan and Fact values from different tables. Both tables - live and already calculated data. 

Is that possbile to do?

[Zubair_Muhammad]

HI @idontexist

Try adding if hasonevalue before your MEASURE

If(hasoneValue(LocalMEasure[Plan]), YourMEASURE)

[idontexist]

Hi @Zubair_Muhammad

But if value is not only one? It could be several values.

[Zubair_Muhammad]

@idontexist

is the Plan Column aggregated in some way?

[idontexist]

@Zubair_Muhammad

It's plan for store for all days in month.  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]

Hi @idontexist,

Can you share the pbix file please? The relationship between two tables could affect the result.

Best Regards,

Dale

[idontexist]

Hi, @v-jiascu-msft

i can do that, but you will not be able to see anything, as it's connected to live cube. And i don't have rights to grant you access.

[v-jiascu-msft]

Hi @idontexist,

As far as I know, we can't create a measure in the mode live to SSAS cube. Did I miss something?

Best Regards,

Dale

[idontexist]

@v-jiascu-msft

We can't create new columns. But new measures we can.

[v-jiascu-msft]

Hi @idontexist,

Hasonevalue could work. Please see the example below. What's your report like? Can you share a snapshot?

Measure 6 =
IF (
    HASONEVALUE ( 'DimProduct'[ClassName] ),
    SUM ( FactSales[SalesQuantity] ),
    0
)

Best Regard,

Dale