Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |