Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
SilasDasGupta
Frequent Visitor

Count measure result of a visual

Hi!

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

SilasDasGupta_0-1643514691553.png

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

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Hi,

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

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

11 REPLIES 11
SilasDasGupta
Frequent Visitor

Hi:

Thanks for your reply.

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

Please see it.

https://drive.google.com/file/d/14uk2K0gta0H5lRQCbMLVALzXLQCxYJL1/view?usp=sharing

 

Thanks again for our kind support. 

Ashish_Mathur
Super User
Super User

Hi,

What is the DAX formula of measure 2? 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi:

Thanks for your reply.

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

Please see it.

https://drive.google.com/file/d/14uk2K0gta0H5lRQCbMLVALzXLQCxYJL1/view?usp=sharing

 

Thanks again for our kind support. 

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.

 

SilasDasGupta_0-1643861802653.png

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

Here is the link of PBIX file:

https://drive.google.com/file/d/1JVCBs9jjb3Kzoy8sAS8gSsWtcnHDzh3G/view?usp=sharing

Looking for your kind support to solve the problem.

 

with regards.

Silas Das Gupta

skype: silas.das.gupta

Hi,

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

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi brother Ashish:

Thank you again for your continue support.

You are my Guru of PowerBi.🙏

 

Regards.

Silas Das Gupta.

 

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
lbendlin
Super User
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. 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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