Forum Discussion

piotrgrendus87's avatar
piotrgrendus87
Icon for Helper I rankHelper I
4 years ago

Forecast Report

Hello Everyone.

I've been trying to build a forecast report for the last few days and I'm very close to finishing it, but I have a few things I can't solve, and I'd really appreciate your help.

How to round a percentage by using a measure in dax ?
I am using this measure to calcuate percentage diffrence beetween two numbers:

Growth Rate WPS % = DIVIDE([Parts R12 2022], [Parts R12 2021]) - 1 + ([Parts]) and receives the result 10,3 %. How to change this measure to get result - 11 %

For some values I have prepared a special filter ( green slicer ), which I can manually increase or decrease the values using the scale %, but the better idea will be to use a slicer with option to move a range from the left to right. A created a table which allow me to only this green slicer how modify my tabel to have possibilty to move slicer from the right to left

 



 
On the main dashboard I have values, each of these values is a separate measure. Is there a method of creating a filter based on measures that allows you to temporarily exclude all measures from a given row so that these results are not counted for the entire projection

 

 And after excluding these measures, they will no longer be included in the average values



Currently, I use the simplest method to calculate the average and I think that in the case of this filter some modification of the code will be required

Average = ([xxx] + [xxx] + [xxx] + [xxx] + [xxx]) / 5

I'd be very grateful for your help.
Best regards, Piotr.