Forum Discussion
Creating a measure based on condition
Hi Anonymous ,
Do share some sample screenshots please of the data and desired output.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Thanks,
Pragati
- Anonymous6 years agoNot applicable
Many thanks for the response. Below pic shows the simplified table to explain what i am trying to achieve:
For the top table, it represents a simplistic table of my data source. I have created 3 measure to determine the distinct count of the number of equipment and the percentage of working equipment. I also wanted to create a measure to calculate number of items that have the % of working equipment status at 0% but i am unsure how to write that in DAX. Therefore, I use the table visual in powerBI to return the results (as shown like in the table below) with the column Description containing the unique values of the list of items.
However, since I need a measure to have the count of the number of items that has status of working equipment at 0%, i went on to create a summary table (summarized based on description of items and with column on the number of equipment and the status of working equipment using the measures that i have created earlier) so that i can count the number of rows of items that has 0% using CountA function. But the results of both table does not tally. Not sure what went wrong here.