Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculated column or Measure

Hi,   Can anyone please help me on the below scenario.   Table 01:  Data in Power BI: DATE USER DESC NAME RV RB Diff FLAG 31/09/2019 NA CP MASTER 1137942.43 0 0 RV not RB ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    You don't have a column to use as hierarchy so I doubt you could create a matrix table.

    Here's the formula for table visual.

    Measure = 
var rb = SUM('Table'[RB])
var rv = SUM('Table'[RV])
return
SWITCH(TRUE(),
        rb<>0&&rv<>0,"RB and RV",
        rb<>0&&rv=0,"RB not RV",
        rb=0&&rv<>0,"RV not RB"
              )

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello Anonymous ,

its working with the similar measure you created. If we use table visual and drop all fields to it its showing aggregated data.

let me know if I misunderstood the scenario