Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Table rows increased drastically when measure is added to table

Hi All,   I have a table visual, where I have to add one measure. The table consists of data from two dimensions tables (in many to many relationship) and one fact table. As soon as I add the measu...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

    It sounds like measure expression expands your records hidden by power bi. I'd like to suggest you add 'if statement' to your formula to check if the current fact table exists in correspond records.

    Measure =
VAR curr =CALCULATE ( SUM ( Fact[Amount] ), VALUES ( Table[Date] ) )
RETURN
    IF ( curr <> BLANK, TODAY )

    Best Regards

    Community Support Team _ Ailsa Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

It sounds like measure expression expands your records hidden by power bi. I'd like to suggest you add 'if statement' to your formula to check if the current fact table exists in correspond records.

Measure =
VAR curr =CALCULATE ( SUM ( Fact[Amount] ), VALUES ( Table[Date] ) )
RETURN
    IF ( curr <> BLANK, TODAY )

Best Regards

Community Support Team _ Ailsa Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Thank you for your kind support. It is exposing all the hidden rows. I have tried your solution, and it worked!!!

 

Regards