Measure the relevance of i item
Hello there again, I need to find out how to calculate the relevance of an item compared to the general value. i have here the dashboard for you to download (ControleDaProducaoMaisLeve&BALSend.pbix) and see. What i need is the item in the visual table to be tested to see its relevance compared to the others, the logic is: if i remove this item, or not consider it, or filter all but leave it out, will the amount of "CountAvailable01" still be the same or it will decrease compared to the value on the card "Ped. Com Potencial"? if it decrease, the item is somehow relevant, if it does not do any difference its no important, a whay to measure the amout is the formula (1-"Ped. Com Potencial"/"CountAvailable01"); with that i will have a percentage of how important that item is to the general situation.. It might feel a little confuse, hope you guys can help me, i've allready tried a lot and used all AI i could to help me. Thankyou a lot
Need help in my DAX measure query
I have a power BI template (shown in image below) In my power BI report, I am trying to update the values for each row in column B. I have the DAX calculations for rows which are not headings like row 3 to 8 and so on, but due to this, my other rows(like row 1 and 2) are getting removed from the power BI report: In the above DAX query, I tried using CurrentItem as the last switch stmt but it is throwing the error: switch does not support values of type true/false with values of type number. consider using value or format func to convert one of the values @daxcommunity @measures
