Forum Discussion

ewuchatka's avatar
ewuchatka
Icon for Helper II rankHelper II
8 years ago

Count if with existing measure

Hello   I've had almost a year-long break from Power BI  and I've tried to look for the answer on the forum but without any luck. I would appreciate your help.   I am trying to recreate COUNT IF ...
Need Help
ewuchatka's avatar
ewuchatka
Icon for Helper II rankHelper II
8 years ago

Hello Ashish_Mathur

 

Thank you for you help! Is this what you need?

 

https://app.powerbi.com/groups/me/reports/2ecf1648-c49e-45d9-8506-bcea705d08b8?ctid=2fc13e34-f03f-498b-982a-7cb446e25bc6

 

I also insert elow of a screenshot in excel where you can see - when I filter on "Agra" manufacturer in excel I need just "1" in WoD but in Power BI there is "2". Formula used in excel is =COUNTIF(B5:B8,"<1.00")

 

I'd like the calculation to work  whenever I filter manufacturer/account/packtype etc like in excel

 

pbi

 .

Thanks

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

No.  I need to download your PBI file.  Upload it to Google Drive/One Drive and share the download link.  Also, i do not see any image in your previous message.