Create Measures related to measure table

[GhadaMehrez]

I have measure based on the measure table {Custom Calculation} when I set the measure as below it is not working and help what is wrong:

% Actuals Booked = COUNT(CustomCulculations, [Actuals Booked])*.01

[GhadaMehrez]

@SpartaBI 

please see here the error message , I hope you can help

[SpartaBI]

@GhadaMehrez already night my timezone so ping me here tomorrow

[GhadaMehrez]

@SpartaBI Hello Thanks for your support, any idea how to fix this as mentioned here I'm need to create a new measure calculating the percentage per strategy category from the total cost, the fields related to estimated total cost is a measure, not a column in a table it is (group of calculation{Custome Calculaion}.

I hope this information makes the issue more visible.

Thanks again

[SpartaBI]

@GhadaMehrez hey are you here now maybe? I have few minutes for zoom / teams

[GhadaMehrez]

@SpartaBI  yes sure available now

[SpartaBI]

@GhadaMehrez 
https://us05web.zoom.us/j/83631361185?pwd=NjNYeXJESUZiZkwwYnhnTTFhM29ZQT09

[GhadaMehrez]

@SpartaBI hi here is an attached simplified copy.https://drive.google.com/file/d/1NeX4G4lb9nYI04D97ygq_StggqvjFIp-/view?usp=sharing 

[SpartaBI]

@GhadaMehrez cool, will be available in an hour and ping you here with a link to zoom

[SpartaBI · Accepted solution]

@GhadaMehrez 
Here is a link to download a sample solution file:
Create Measures related to measure table 2022-08-10.pbix

I created few versions of the measure. 
Depending on your use case one of them will probably be the right one.
For the sake of the sample all are giving the same result.

Showcase Report – Contoso By SpartaBI



      

[GhadaMehrez]

Thanks, But this Measure not works as in my original file the estimated total cost is not in table it is measure. 

$ ETC = SUM('Table'[Estimated Total Cost]) 

 Then I tried to make it like this but also it is not giving the right output.

$ ETC = [Estimated Total Cost]

[SpartaBI]

What is your original measure for estimated cost?

[SpartaBI]

@GhadaMehrez please join, I have 5 minutes 🙂

[GhadaMehrez]

any advice on how to fix this measure I think it is about aggregation, what can I use to give me the result as {Count}

[Tsrivastava]

Could use 
% Actual Booked = 
var Countcalculation = count(CustomCalculation)
Return 
divide(Countcalculation , [ActualBooked]) * 0.1

[GhadaMehrez]

not working still have error:

[SpartaBI]

@GhadaMehrez what are you trying to do? The function itsled is written wrong.
Maybe share you file and tell what is the result you want to get?

[GhadaMehrez]

I'm trying to convert the Value of estimated total cost per category in percentage as below: