cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

## Calculate several numeric values

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?

9 REPLIES 9
Community Champion

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

Regards
Zubair

Helper I

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

Community Champion

@idontexist

is the Plan Column aggregated in some way?

Regards
Zubair

Helper I

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.

Employee

Hi @idontexist,

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

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper I

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.

Employee

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper I

@v-jiascu-msft

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

Employee

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.