Forum Discussion

Saxon10's avatar
Saxon10
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

How do I combine two visuals reports into one Power BI visual report

Hi,   I have the following columns are Id, Code, Result1 and Result2 in data table. The same id and code has two different status.   I am currently using two different visual for same id and code...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Create a new table either via the query editor or a DAX calculated table.

     

    As a calculated table, for example:

    Slicer = DATATABLE ( "Result", STRING, {{"Result 1"}, {"Result 2"}} )

     

    See attached.

     

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

Define a new table Slicer with a single column "Result 1" and "Result 2".

Then you can define a measure

VarResult =
SWITCH (
    SELECTEDVALUE ( Slicer[Result] ),
    "Result 1", SELECTEDVALUE ( Data[Result 1] ),
    "Result 2", SELECTEDVALUE ( Data[Result 2] )
)

 

Saxon10's avatar
Saxon10
Icon for Post Prodigy rankPost Prodigy
4 years ago

AlexisOlson

 

Can you please advise one more thing here, I would like achieve the same result by using New calculate column instead of measure. Is that possible?

  • So I can use the Var results in row and column for count and additional reporting purposes. 
  • The current Var results unable to use count 

 

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    A calculated column cannot read a slicer, so no, there isn't an equivalent for a calculated column.

    • Saxon10's avatar
      Saxon10
      Icon for Post Prodigy rankPost Prodigy
      4 years ago

      Thanks for your reply and advise.