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
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