Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I want to count from measure "Multi", "Solo"
I used this measure
Solved! Go to Solution.
HI @MSAYED26,
You can try to use the following measure to calculate the result based on current measure value group:
formula =
VAR summary =
SUMMARIZE (
ALLSELECTED ( Table1 ),
[Materials],
"M1", [Measure1],
"M2", [Measure2]
)
RETURN
COUNTX (
FILTER ( summary, [M2] IN VALUES ( NewTable[Materials] ) ),
[Materials]
)
Regards,
Xiaoxin Sheng
I used the measure but no data
HI @MSAYED26,
You can try to use the following measure to calculate the result based on current measure value group:
formula =
VAR summary =
SUMMARIZE (
ALLSELECTED ( Table1 ),
[Materials],
"M1", [Measure1],
"M2", [Measure2]
)
RETURN
COUNTX (
FILTER ( summary, [M2] IN VALUES ( NewTable[Materials] ) ),
[Materials]
)
Regards,
Xiaoxin Sheng
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
19 | |
18 | |
18 | |
15 |
User | Count |
---|---|
38 | |
20 | |
18 | |
16 | |
10 |