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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Measures in measure, multiplying columns to a measure

Hi All,

I faced with a complicated issue..I have to implement the excel calculation in power BI because the user wants to enter the value (I am making use of whatif parameter as of now, any other suggestions on the same will also be appreciated)

Please find the attached file 

I want to calculate following parameters

1. Input-ISS(K)

2. Input-ISS(Days)

3. Input-IMS(Days)

 

Major issue that I am faced with is that there I have to use over 20 measures (due to ripple effect and the dependencies) and to top this up..I need to summarise the data and show at different levels (You can look at the filters)..which also means that I will be using further calculated columnssimulation.JPG

 

I will share the file through drop box. I have two questions 

1. The calculation as of now takes 1-2 seconds, but i have data only for 2400 rows. Going forward I would be looking at getting at least million rows. Also note I still need to add further calculated rows and measures. would this be possible??

2. Is there any other way to this (i.e. take the input from user once the report is published)?

3. Also is there any possibility of taking the input from the user and doing calculation in excel or R, and bring it back to power bi?

 

Any suggestion would be appreciated.

Kind Regards,

nsa444

5 REPLIES 5
v-yuta-msft
Community Support
Community Support

@Anonymous,

 


1. The calculation as of now takes 1-2 seconds, but i have data only for 2400 rows. Going forward I would be looking at getting at least million rows. Also note I still need to add further calculated rows and measures. would this be possible??

2. Is there any other way to this (i.e. take the input from user once the report is published)?

3. Also is there any possibility of taking the input from the user and doing calculation in excel or R, and bring it back to power bi?

 


 

The sample file you shared seems to be expired. However, to be general, for question1, you need to improve the performance of DAX, right? You may refer to: https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance and http://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques. For question2, I'm afraid currently there's no such feature in power bi. In addtion, for question3, I would suggest you to use R visual or python visual in power bi which can interact with the user's selection in slicer. Reference: https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals and https://docs.microsoft.com/en-us/power-bi/desktop-python-visuals.

 

 

Anonymous
Not applicable

@v-yuta-msft

Thank you for replying to my query. I am reuploading the link for the file. The model has around 20 measures and each measure is dependent on the preceeding measure and columns (for this I am using max) there are twenty measures in total (still coming...)

I need to take summation of these measures on the various levels of filters

new Link:

https://www.dropbox.com/s/gumtnbvsgrawxo0/Simulation%20File.pbix?dl=0

Thanks once again!

 

@Anonymous,

 

Could you clarify your requirement and expected results?

 

Community Support Team _ Jimmy Tao

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

Anonymous
Not applicable

Hi Jimmy,

Thanks for replying to my query.

As you can see I am taking inputs from the end user through whatif parameters. and i have measures that are interdependent.

I am looking to calculate

1. Input-ISS(K)

2. Input-ISS(Days)

3. Input-IMS(Days) 

and I need to display these measures at the level of the country, TOLC, SKC in seperate tables (as you know the meaures are not that great when displaying the total)

I have no issues with the data on the most granular level (I have verified the calculations with excel), but when I start aggregating the data, the results are not accurate. 

So what I am asking is how to take the sum of measure at the country, TOLC, SKC level. 

and as of now, the calculation runs smoothly, but as I asked before, let's say if I have a million rows...

would the calculation take more time? (At the present I only have 2400 rows)

Thanks once again

nsa444

Anonymous
Not applicable

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.