Forum Discussion

shuiting's avatar
shuiting
Frequent Visitor
7 years ago
Solved

Line Chart question

Fairly new to Power BI and I am having an issue that I can't seem to resolve. I don't know if I'm asking this in the right way, but I have a line chart with two lines of data on it. X-axis is made up...
Need Help
  • shuiting's avatar
    shuiting
    7 years ago

    After a lot of trial and error, I figured out the solution. 

     

    Measure = IF(

       CALCULATE(

          COUNTA(table.column,table.column IN { "value A" })>0

     ||

       CALCULATE(

          COUNTA(table.column),table.column IN { "value B" })>0,

       COUNTA('YTD (2)'[Call/Email])+0,

       COUNTA('YTD (2)'[Call/Email])

    )

     

    you can copy and paste the CALCULATE function along with addition || operators to account for more values. Side note, || is equal to OR.

     

shuiting's avatar
shuiting
Frequent Visitor
7 years ago

After a lot of trial and error, I figured out the solution. 

 

Measure = IF(

   CALCULATE(

      COUNTA(table.column,table.column IN { "value A" })>0

 ||

   CALCULATE(

      COUNTA(table.column),table.column IN { "value B" })>0,

   COUNTA('YTD (2)'[Call/Email])+0,

   COUNTA('YTD (2)'[Call/Email])

)

 

you can copy and paste the CALCULATE function along with addition || operators to account for more values. Side note, || is equal to OR.