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.
Hi all,
I am making a matrix visual and adding measures to the values field in the visualization fields. I only want to show measures with non blank rows. How can I do that? Is there a measure through which I can do it? I would really appreciate feedback on how this can be done or for any other alterntive approach. I have attached my matrix visual aling with the table structure in the images below. The values in the pictures are random and are for illustrative purposes only.
Solved! Go to Solution.
Hi,
Please take following steps:
1)Create a new calculated table:
Table =
CROSSJOIN (
DISTINCT ( SELECTCOLUMNS ( 'Master', "HEAD", Master[ROW 1] ) ),
DATATABLE (
"MEASURE", STRING,
{
{ "Measure 1" },
{ "Measure 2" },
{ "Measure 3" },
{ "Measure 4" }
}
)
)
2)Try this measure:
Measure =
SWITCH (
SELECTEDVALUE ( 'Table'[MEASURE] ),
"Measure 1", [Measure 1],
"Measure 2", [Measure 2],
"Measure 3", [Measure 3],
"Measure 4", [Measure 4]
)
3)The result shows:
Here is my test pbix file:
Hope this helps.
Best Regards,
Giotto
Hi,
Please take following steps:
1)Create a new calculated table:
Table =
CROSSJOIN (
DISTINCT ( SELECTCOLUMNS ( 'Master', "HEAD", Master[ROW 1] ) ),
DATATABLE (
"MEASURE", STRING,
{
{ "Measure 1" },
{ "Measure 2" },
{ "Measure 3" },
{ "Measure 4" }
}
)
)
2)Try this measure:
Measure =
SWITCH (
SELECTEDVALUE ( 'Table'[MEASURE] ),
"Measure 1", [Measure 1],
"Measure 2", [Measure 2],
"Measure 3", [Measure 3],
"Measure 4", [Measure 4]
)
3)The result shows:
Here is my test pbix file:
Hope this helps.
Best Regards,
Giotto
Hi! I can not download pbix. Error NOT FOUND 404.Could you please upload again?
thank you so much
You can create measure with all except, which represent row total and use that as a filter in visual
Refer , how to create:https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept...
Hi @commonsenseuser ,
You must have created calculations for your Measure1, Measure2, Measure3, Measure 4 using DAX calculation.
As you haven't shared formula for your above measures, I can add that, in your measure calculation, try to calculate only NON BLANK results.
If you can share your Measure calculations, it's easy to highlight the change.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Thank you for the reply.
Here is a measure that I am using for this matrix:
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |