Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone !
I have a simple request but i tried different ways but I didn't solve it.
I would like to count how many times I have a blank rows, here is the field " Groupe mandataire retraité" (the first row).
Here is the matrix :
Here, is an excel with the expected result :
I tried all those possibilities :
Measure 1 = COUNTBLANK(groupe mandataire retraité [groupe mandataire retraité])
Result : Blank (because there are blank in data?)
Measure 2 =
Result = Nothing happened
Solved! Go to Solution.
To count the number of blank rows based on the "Groupe mandataire retraité" column in Power BI using DAX, you can use the following approach:
Here are the steps to implement this:
Create a calculated column:
BlankRowCheck = ISBLANK('YourTableName'[Groupe mandataire retraité])
Replace 'YourTableName' with the name of your table.
Create a measure to count blank rows:
BlankRowCount = COUNTROWS(FILTER('YourTableName', 'YourTableName'[BlankRowCheck]))
Replace 'YourTableName' with the name of your table.
After creating the measure, you can add it to a card visual to display the number of blank rows based on the "Groupe mandataire retraité" column.
This approach should give you the count of blank rows as expected in your Excel example. Make sure to replace 'YourTableName' with the actual name of your table in Power BI.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.
To count the number of blank rows based on the "Groupe mandataire retraité" column in Power BI using DAX, you can use the following approach:
Here are the steps to implement this:
Create a calculated column:
BlankRowCheck = ISBLANK('YourTableName'[Groupe mandataire retraité])
Replace 'YourTableName' with the name of your table.
Create a measure to count blank rows:
BlankRowCount = COUNTROWS(FILTER('YourTableName', 'YourTableName'[BlankRowCheck]))
Replace 'YourTableName' with the name of your table.
After creating the measure, you can add it to a card visual to display the number of blank rows based on the "Groupe mandataire retraité" column.
This approach should give you the count of blank rows as expected in your Excel example. Make sure to replace 'YourTableName' with the actual name of your table in Power BI.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.
To count the number of blank rows based on the field "Groupe mandataire retraité" in Power BI using DAX, you can create a new calculated column or measure depending on your requirement.
Here's how you can do it:
Create a new calculated column: You can create a new calculated column using the following DAX formula:
BlankRowCount = IF(ISBLANK([Groupe mandataire retraité]), 1, 0)
This formula will assign a value of 1 to the new column if the "Groupe mandataire retraité" field is blank, and 0 otherwise.
Create a measure: If you prefer to use a measure to dynamically calculate the count of blank rows, you can create a measure using the following DAX formula:
BlankRowCount =
COUNTROWS(FILTER('YourTableName', ISBLANK('YourTableName'[Groupe mandataire retraité])))
Replace 'YourTableName' with the name of your table where the data is stored.
Once you have either the calculated column or measure in place, you can add it to your report and it will show the count of blank rows based on the "Groupe mandataire retraité" field.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.
try this:
CALCULATE(COUNTROWS('groupe mandataire retraité'),ISBLANK('groupe mandataire retraité'[groupe mandataire retraité])
User | Count |
---|---|
58 | |
21 | |
19 | |
17 | |
16 |
User | Count |
---|---|
85 | |
80 | |
52 | |
37 | |
22 |