Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
idontexist
Helper I
Helper I

Calculate several numeric values

Hi guys,

 

I need to calculate values like the following:

 

 PlanFactNew measure
 15  
 15  
 15  
 15  
 151515
 15  
 15  
 15  
 15  
 15  
 15  
 15  
Total1801515

 

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
Zubair_Muhammad
Community Champion
Community Champion

HI @idontexist

 

Try adding if hasonevalue before your MEASURE

 

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


Regards
Zubair

Please try my custom visuals

Hi @Zubair_Muhammad

 

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

@idontexist

 

is the Plan Column aggregated in some way?


Regards
Zubair

Please try my custom visuals

@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.

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.

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.

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.

@v-jiascu-msft

 

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

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
)

Calculate_several_numeric_values

 

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.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.