Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Trying to create a percentage based on two different fields depending on which model, how many returns processed / total units produced. I made some attempts that did not work but the very basic idea of what I need would be Formula count / total produced. The measure for Formula Count is shown in the picture. I also know that some Total Produced values are blank. I am pretty new to Power BI so hopefully this isn't something too obvious. The reason it has not worked for me so far is that there are multiple values where PowerBI expects one value to be present (the Total Produced column).
ced.
I think this can help.
Always use "/Calculate AllSelected" to get percentages, for me is the best way.
and the "if isblank" fixes the problem with lines without values.
Percentage = if( Isblank(
Counta(AviationTable[Unit Description])) ;0 ;Counta(AviationTable[Unit Description]) /CALCULATE(Counta(AviationTable[Unit Description]);AllSelected())
I Hope to have helped
Im not an expert at all, but did you try:
Percentage = [Formula Count] / [Total Produced]
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!