Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

rounded measure total in table

The table below is using a rounded measure.  The Total of the AE or NTC column is totaling to 1 even though the individual cells are 0.  I'm assuming that the Total is also applying the formula versu...
Chihiro's avatar
Chihiro
Solution Sage
7 years ago

This really depends on how your table is structured.

 

Assuming that you have... table with individual rows (summarized by Career Band).

 

Ex:

 

You can use something like...

Measure =
SUMX ( TableName, ROUND ( TableName[Val] * 0.05, 0 ) )

 

But exact method will depend on your underlying model/table structure.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks for the response - I tried your formula (and I'll admit - I am not familiar with that one) and got some really different results.

     

    Here is the actual formula I've used:

    PR_AE/Prob/NTC = round((count(FFile[ID 1 ]) * 'NTC/AE/Prob'[NTC/AE/Prob Value]),0)

     

    It is finding the count based on slicers I've selected on the page and applying the default value of a What If parameter (5%).

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi Anonymous,

       

      Did Chihiro's solution work? If not, can you provide a sample file?

       

       

      Best Regards,
      Dale