cancel
Showing results for
Did you mean:

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.

Frequent Visitor

## Count measure result of a visual

Hi!

I got result calculate a mesure like below, (it is in the report page:.)

I want to make a chart based on the result measured. My result will be as follow based on the measure:

Green = 8

Red = 6

Yellow = 1

Please note that choosing slicer option result will be changed of the measure 2.

Looking for help.

Regards.

2 ACCEPTED SOLUTIONS
Super User

Hi,

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

Hi,

Select the visual and drag the Total Weight column to the visual filter section.  Apply a condition there of >0.

Regards,
Ashish Mathur
http://www.ashishmathur.com
11 REPLIES 11
Frequent Visitor

Hi:

Here I am sending the pbi file for your quick understanding and support.

Thanks again for our kind support.

Super User

Hi,

What is the DAX formula of measure 2?

Regards,
Ashish Mathur
http://www.ashishmathur.com
Frequent Visitor

Hi:

Here I am sending the pbi file for your quick understanding and support.

Thanks again for our kind support.

Super User

Hi,

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Frequent Visitor

Hi brother Ashish:

Come back to you aging, need another help.

Please see the below screen shot, I am trying to ignore blank meaure in the visual but can not do it. Please note that this blank value is infinite value.

My chart will show as Green=3, Yellow=1 and Red=1

Here is the link of PBIX file:

Looking for your kind support to solve the problem.

with regards.

Silas Das Gupta

skype: silas.das.gupta

Super User

Hi,

Select the visual and drag the Total Weight column to the visual filter section.  Apply a condition there of >0.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Frequent Visitor

Hi brother Ashish:

Thank you again for your continue support.

You are my Guru of PowerBi.🙏

Regards.

Silas Das Gupta.

Super User

You are welcome.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Frequent Visitor

Dear Asish:

Thank you so much for your kind support and cooperation.

I got my result as I expected.

Thanks again, wishing for the best.

Silas

Super User

You are welcome.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

You cannot group measure results. You need to create an entirely new measure that calculates the grouping.

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with.

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors