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
Earl40
Helper I
Helper I

Measure to count values over a number then show as 0% of total

Hi Im new to PowerBi any help would be appreciated

 

I have data set that has a column showing the aging of each item. I want to create a measure to count all the values greater than 13 then show that as a % of all the values in a Power Bi card. If theres item with a value grater than 13 then show 0%

 

Thank you in advance

 

heres an basic example of the data

Earl40_0-1701395880691.png

 

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

7 REPLIES 7
Ahmedx
Super User
Super User

and you can try this

Screenshot_3.png

Ahmedx
Super User
Super User

pls try

Screenshot_2.png

@Ahmedx Thanks in my actual table the age column is a number, but the second part of the formula in VAR _t1 doesnt pick up the age column in the table. its only shows other  measures it doesnt show the column name i need

I don’t understand, Age is a measure and not a column?

share the real file or explain in detail

@Ahmedx  I apologize ill clarify. Im still very new to PowerBi. I wish i could post the file but its work related. 

 

ok so in my file Age is a column. To try your solution

I first created a new measure on the table I want it to be part of. 

I typed in the first past of the solution  "VAR and then space the _t1 = calculate(countrows(table name)" .. now when i try to enter the second part which is the table name and the column name Age the option doesnt populate. The only column names that populate are either from other measures or columns that I created and doesnt give me an option to select the column name age. I try to type it also but it just errors

 

 

Earl40_0-1702347240951.png

 

take a screenshot of what you wrote

@Ahmedx  never mind now it works. I probavbly did something wrong yesterday. Thank you so much for your help

 

Only issue im having now is I only want it to show the last 3 months  and when i add another column called date closed which is a date column as  filter on the card for 3 months it goes to blank instead of showint 0%

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.