Forum Discussion

AudreyWen's avatar
AudreyWen
Icon for Helper I rankHelper I
6 years ago

Measure only at selected row

Hi All,   I use a measure in a report and i want this measure only to use the rows with a specific selected value.   A row has a status in column "Status". for example: "Delivered" or "Open" or "...
Anonymous's avatar
Anonymous
Not applicable
6 years ago
I'm not sure if you know the difference between a measure and a calculated column... If we can't agree on the meaning of words, then I won't be able to help. Sorry.

Best
D
AudreyWen's avatar
AudreyWen
Icon for Helper I rankHelper I
6 years ago

Hi,

 

I know the difference. I make a new measure in the report on table AvStockLevel. There i put the measure. Than i drag the measure and put it in the table that i have in my report. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    OK. So then, what's exactly wrong with the measure with my additions? Because we still don't know...

    Best
    D
  • AudreyWen's avatar
    AudreyWen
    Icon for Helper I rankHelper I
    6 years ago

    Hi,

     

    I don't know. Maybe nothing is wrong with it, but maybe there are to many rows (60.565) in the dataset and that will only be more everytime.

    In my first measure it was the same problem it kept on loading when i put the measure in my report. Then I have made a new dataset with an Excelfile with only the rows with the status i need (741 rows at the moment, sometimes it will be more or less), then the measure works perfectly in my report. Only now I have to update my model, export the rows to Excel everytime and than i must update the model again. This will be to confusing if my colleagues have to work with this later on.  I'm hoping to find a way that it will work at ones.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Power BI is built on tabular databases that can easily handle tens of millions of rows. A measure can be slow if there is a lot of computation in it and the CPU is not powerful enough. Or it might be slow because it's written inefficiently. But if this is the case it should be optimized. For optimization techniques you should consult the book by The Italians - The Ultimate Guide to DAX.

    Best
    D
  • AudreyWen's avatar
    AudreyWen
    Icon for Helper I rankHelper I
    6 years ago

    Hi,

     

    I will check it.

     

    And many thanks for your replies and your time!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    If you want to stay away from trouble, please NEVER expose fields in your fact tables to the user. Slice only through dimensions. If you decide to override this rule, you'll be in for a surprise rather sooner than later... and you'll not know why the numbers are what they are.

    You can trust me on this one 🙂

    Best
    D