Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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 🙂
Solved! Go to Solution.
Hi @Xilitor01 ,
Try this measure:
_yourMeasureCombined =
IF(
NOT ISBLANK([Measure 3]),
[Measure 3],
IF(
NOT ISBLANK([Measure 2]),
[Measure 2],
[Measure 1]
)
)
Pete
Proud to be a Datanaut!
Hi @Xilitor01 ,
Try this measure:
_yourMeasureCombined =
IF(
NOT ISBLANK([Measure 3]),
[Measure 3],
IF(
NOT ISBLANK([Measure 2]),
[Measure 2],
[Measure 1]
)
)
Pete
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |