Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

countif function excel replication powerbi dax measure

I need help with replicating the countifs function in Excel to DAX measures in PowerBI:   Filter Cust_Segment, Filter product_Type WHERE Actual_SOL_Wk <= Week Of AND PTS_Wk < WeekOf AND Actual_PTS_...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello, 

 

Can you at least help me understand the errors?

 

PD Not Finished Play 4 is showing errors like this:

 

MdxScript(Model) (28,32) Calculation error in measure 'Measure Table'[Day of] : A table of multiple values

was supplied where a single value was expected. 

 

For PD Not Finished Play 9 is showing errors like this: 
 
" A function 'Filter' has been used in a True/False expression that is used as a table filter expression. This is 
not allowed" 

 

Greg_Deckler Amit amitchandak lbendlin DataInsights speedramps  johnt75 davehus Ashish_Mathur 

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous The error you are getting means that somewhere in your formula you are returning a table of values when DAX is expecting a scalar (single value). 

 

Over the years, I've learned this lesson. It's mostly a waste of time to try to answer complex calculation issues without sample data. It's just too hard to get the DAX correct and the visual configuration correct, etc. This is what is important:

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

 

Otherwise, it's just not efficient and there are a million variables involved as to why things won't work the way you want.