Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How do exclude a certain row's calculation in a Matrix?

Hi all, here is my data structure

 

 

How do i create a generic fomula for Multiple in PowerBI to exclude A from it? (i.e., excluding A when applying the fomula in column E but keep C and D including A)

 

Thanks. 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    Try these measures

    Ratio = divide([cash inflow],[cash outflow])

    Ratio final = calculate([Ratio],Data[Project]<>"Project A")

    Hope this helps.

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

    I am not clear about what you want.  Assuming Cash inflow and Cash outflow are measure, write this measure

    Measure = divide([Cash inflow],[cash outflow])

    Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I need to exclude Project A from the total calculation.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      Hi,

      Try these measures

      Ratio = divide([cash inflow],[cash outflow])

      Ratio final = calculate([Ratio],Data[Project]<>"Project A")

      Hope this helps.