Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Xilitor01
Helper III
Helper III

Combine three measures into one

Hello,

 

I currently have the four categories below with three measures.

Instead of them listed in different columns I want the measures to be in the same column:

Xilitor01_0-1627369086060.png

 

The data is setup like:

Table 1: Quiz[Measure1] and Survey[Measure1]

Table 2: Raffle[Measure2]

Table 3: Voucher[Measure3]

 

The idea of the matrix is to give an overview and therefore doesn't need to filter correctly.

 

Thanks in advance 🙂

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Hi @Xilitor01 ,

Try this measure:

 

_yourMeasureCombined =
IF(
  NOT ISBLANK([Measure 3]),
  [Measure 3],
  IF(
    NOT ISBLANK([Measure 2]),
    [Measure 2],
    [Measure 1]
  )
)

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

1 REPLY 1
BA_Pete
Super User
Super User

Hi @Xilitor01 ,

Try this measure:

 

_yourMeasureCombined =
IF(
  NOT ISBLANK([Measure 3]),
  [Measure 3],
  IF(
    NOT ISBLANK([Measure 2]),
    [Measure 2],
    [Measure 1]
  )
)

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.