Results 1 to 2 of 2

Thread: Why can't I make measures in PBI

  1. #1
    Seeker RonaldLieuw's Avatar
    Join Date
    Sep 2019
    Posts
    11
    Articles
    0
    Excel Version
    2010

    Why can't I make measures in PBI



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    I am trying to define two new measures for the table ToetsingNaf in PBI, but it does not let me do that.
    The worksheet has two tables which I imported into PBI.
    For the table ToetsingNaf I had to make two new columns Verschil 1 and Verschil 2 (formatted as %).

    Verschil 1 = (ToetsingNaf[Tot_inv_Naf]- ToetsingNaf[GgM-Naf])/ToetsingNaf[Tot_inv_Naf]
    Verschil 2 = (ToetsingNaf[GgM-Naf]-ToetsingNaf[Gg_Gdoc_Naf])/ToetsingNaf[GgM-Naf]

    Instead of the new calculated columns I wanted to define two measures Verschil 1 and Verschil 2 instead of the columns.
    Why can't I make these measures?
    Attached Files Attached Files
    Last edited by RonaldLieuw; 2019-10-19 at 07:46 PM.

  2. #2
    Seeker RonaldLieuw's Avatar
    Join Date
    Sep 2019
    Posts
    11
    Articles
    0
    Excel Version
    2010
    I found the solution, this is the correct format:
    Measure = sumx(ToetsingNaf, (ToetsingNaf[Tot_inv_Naf]-ToetsingNaf[GgM-Naf])/ToetsingNaf[Tot_inv_Naf])


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •